支持

=0.51 , [Circuit Quote % Status]@row<=0.95, [End Date]row,…","categoryID":322,"dateInserted":"2022-09-16T19:27:43+00:00","dateUpdated":null,"dateLastComment":"2022-09-17T16:06:33+00:00","insertUserID":151274,"insertUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2023-04-06T17:41:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":151274,"lastUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2023-04-06T17:41:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":180,"score":null,"hot":3326789056,"url":"https:\/\/community.smartsheet.com\/discussion\/95454\/task-health","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95454\/task-health","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/K3KPF24CX85O\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-09-16T22:29:27+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":95088,"type":"question","name":"TASK % COMPLETE FORMULA","excerpt":"I created a column to be provide me the task (row) total % complete. The two columns below have a dropdown status that each represent a % complete The % for each status is below: =IF([2nd Circuit Status]@row = “N\/A”, IF(OR([1st Circuit Status]@row = “Waiting to sign the contract”, [1st Circuit Status]@row = “Waiting for…","categoryID":322,"dateInserted":"2022-09-06T19:10:55+00:00","dateUpdated":"2022-09-15T20:12:14+00:00","dateLastComment":"2022-09-17T16:01:27+00:00","insertUserID":151274,"insertUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2023-04-06T17:41:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":150538,"lastUserID":151274,"lastUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2023-04-06T17:41:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":228,"score":null,"hot":3325926142,"url":"https:\/\/community.smartsheet.com\/discussion\/95088\/task-complete-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95088\/task-complete-formula","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/1SK8Y124XWFR\/image-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.PNG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-09-06T19:50:58+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":94976,"type":"question","name":"Calculate the right average for the columns","excerpt":"I need the average collect to calculate the right total % complete for the columns Each column that has a date is = 100% If there is no date is = 0% but the formula still counts the 0% to give the total % average complete on \"Quote % Complete\" column. If there is \"N\/A\" either in \"1st Circuit Quote Status or 2nd Circuit…","categoryID":322,"dateInserted":"2022-09-01T17:14:27+00:00","dateUpdated":null,"dateLastComment":"2022-09-15T15:42:20+00:00","insertUserID":151274,"insertUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2023-04-06T17:41:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":151274,"lastUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2023-04-06T17:41:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":218,"score":null,"hot":3325314407,"url":"https:\/\/community.smartsheet.com\/discussion\/94976\/calculate-the-right-average-for-the-columns","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94976\/calculate-the-right-average-for-the-columns","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/CIJM82BX3BRT\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-06T19:15:45+00:00","dateAnswered":"2022-09-06T14:40:05+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":95276,"type":"question","name":"How to convert to a date","excerpt":"HI all, I'm trying to get a text string from one column (lot code) converted into a date in another column. The first column contains numbers such as: 202405 Ideally the date column would read the first four digits as a year, and the last two as the month (all of the days can be the first). So far I have: =DATE(LEFT([LOT…","categoryID":322,"dateInserted":"2022-09-12T20:04:51+00:00","dateUpdated":null,"dateLastComment":"2022-09-13T13:09:06+00:00","insertUserID":152235,"insertUser":{"userID":152235,"name":"ashleyp","url":"https:\/\/community.smartsheet.com\/profile\/ashleyp","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!m8sp3z_RZcs!!s8r7-c-BNcO","dateLastActive":"2022-09-19T21:14:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":380,"score":null,"hot":3326089437,"url":"https:\/\/community.smartsheet.com\/discussion\/95276\/how-to-convert-to-a-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95276\/how-to-convert-to-a-date","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-12T21:24:02+00:00","dateAnswered":"2022-09-12T20:46:51+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":281,"urlcode":"support","name":"Support"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":94671,"type":"question","name":"How to get updated dates in CC Summary Sheet","excerpt":"Hi, I am trying to set update the summary sheet for our Control Center blueprint to show dates from the project plan rather than the original dates entered in the intake sheet. The new dates are captured in the summary data on our schedule sheets, and are selected as profile data (as date types), but they don't appear in…","categoryID":343,"dateInserted":"2022-08-25T15:36:44+00:00","dateUpdated":"2022-08-25T16:38:59+00:00","dateLastComment":"2022-08-31T09:45:21+00:00","insertUserID":112101,"insertUser":{"userID":112101,"name":"cbrucher","url":"https:\/\/community.smartsheet.com\/profile\/cbrucher","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!86vXt72zxP4!eiDU5y3VGGY!steIrAKZC6R","dateLastActive":"2023-08-24T21:37:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":91566,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":198,"score":null,"hot":3323381525,"url":"https:\/\/community.smartsheet.com\/discussion\/94671\/how-to-get-updated-dates-in-cc-summary-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94671\/how-to-get-updated-dates-in-cc-summary-sheet","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/TWV2ZUC4F0Q9\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-08-31T09:45:21+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">