公式

I would want the formula to read all of those tasks and…","categoryID":322,"dateInserted":"2018-12-17T18:30:16+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-19T12:46:24+00:00","insertUserID":72746,"insertUser":{"userID":72746,"name":"Frank_Mattiace","url":"https:\/\/community.smartsheet.com\/profile\/Frank_Mattiace","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-02T12:24:59+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-06-15T21:50:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":156,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/37706\/current-task-formula-based-off-certain-criteria-symbols","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/37706\/current-task-formula-based-off-certain-criteria-symbols","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-12\/39\/4b\/394bb78fb3cef1e93a68cbbf7d134162.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2018-12-17 at 6.28.49 PM.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":214,"urlcode":"Search","name":"Search"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"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":37371,"type":"discussion","name":"Getting status of a RYG with a Date Column","excerpt":"Greetings, Thank you for taking the time to read this. I am a newbie to both programming functions and to Smartsheet. I am working on a sheet where I require to report out the RYG Balls on the end of calendar months. I have two columns I need to create a function for- \"Date of Update\" and \"Status Report.\" When the Status…","categoryID":322,"dateInserted":"2018-12-13T13:02:38+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-19T10:21:29+00:00","insertUserID":40831,"insertUser":{"userID":40831,"name":"pbeahn40831","url":"https:\/\/community.smartsheet.com\/profile\/pbeahn40831","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-18T18:15:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":39511,"lastUser":{"userID":39511,"name":"eric.o","url":"https:\/\/community.smartsheet.com\/profile\/eric.o","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-11\/b4\/72\/nb47282e48b112cb30b474010a6cdfb22.jpg","dateLastActive":"2019-02-26T06:44:46+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":105,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/37371\/getting-status-of-a-ryg-with-a-date-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/37371\/getting-status-of-a-ryg-with-a-date-column","format":"Html","groupID":null,"statusID":0,"attributes":{},"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"}],"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":37306,"type":"discussion","name":"Translating Date Formats","excerpt":"We have Smartsheet integrated with another system and pulling data across into Smartsheet. Currently the date format that is coming across is (YYYY-MM-DD) and I want to translate that into my local profile date format of (MM\/DD\/YY). Is there a function or formula that allows me to do this? I have been unsuccessful in my…","categoryID":322,"dateInserted":"2018-12-12T15:58:37+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-19T07:00:54+00:00","insertUserID":72071,"insertUser":{"userID":72071,"name":"mark.bromley72071","url":"https:\/\/community.smartsheet.com\/profile\/mark.bromley72071","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-02-22T10:37:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"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-06-17T08:06:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":208,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/37306\/translating-date-formats","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/37306\/translating-date-formats","format":"Html","groupID":null,"statusID":0,"attributes":{},"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":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":37741,"type":"discussion","name":"If Statement for three columns","excerpt":"Hi Guys! I am working on the following Formula: =IF(AND([Date Completed]1 < (TODAY(-3)), Cause1 = \"\", Correction1 = \"\"), \"Overdue\", \"OK\") Goal: If the date in a date column [Date Completed] is more than 3 days ago, and the cells for the next two columns are empty - one or both - I want to remind our technicians to fill…","categoryID":322,"dateInserted":"2018-12-18T09:36:56+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-18T16:26:18+00:00","insertUserID":72801,"insertUser":{"userID":72801,"name":"Kevin Sitech","url":"https:\/\/community.smartsheet.com\/profile\/Kevin%20Sitech","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-01\/a7\/1d\/na71d8d475d4377bb12ad7b0558229b24.jpg","dateLastActive":"2019-01-22T12:09:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":72801,"lastUser":{"userID":72801,"name":"Kevin Sitech","url":"https:\/\/community.smartsheet.com\/profile\/Kevin%20Sitech","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-01\/a7\/1d\/na71d8d475d4377bb12ad7b0558229b24.jpg","dateLastActive":"2019-01-22T12:09:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":127,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/37741\/if-statement-for-three-columns","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/37741\/if-statement-for-three-columns","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-12\/48\/e3\/48e3edd2f4bd567ada345353eec09e58.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"formula.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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":37721,"type":"discussion","name":"if statement","excerpt":"Hi, Can someone help me on this formula. Please check the formula if the % is greater than 100 % its should shows as Yes but in my formula its showing as No. ","categoryID":322,"dateInserted":"2018-12-18T03:23:11+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-18T03:51:59+00:00","insertUserID":69891,"insertUser":{"userID":69891,"name":"Jimmy","url":"https:\/\/community.smartsheet.com\/profile\/Jimmy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-02-19T07:54:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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-06-17T08:06:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":75,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/37721\/if-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/37721\/if-statement","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-12\/5a\/73\/5a738a0097373195c1fa1f4a0b9dec8c.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"% formula.PNG"},"attributes":{},"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"}],"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":5915,"type":"discussion","name":"If Status is \"Completed\" then make % Complete \"100%\"","excerpt":"I need help with the formula to automatically make the % Complete be 100% for any row where Status is \"Completed\" Do I put the formula in the % Complete cell? And if so, what formula? What I have tried so far does not work: =IF(Status=Completed,%Complete=100%) That's probably wrong for a variety of reasons, but I can't…","categoryID":318,"dateInserted":"2016-08-25T11:51:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-17T21:10:19+00:00","insertUserID":7133,"insertUser":{"userID":7133,"name":"pentatonic145","url":"https:\/\/community.smartsheet.com\/profile\/pentatonic145","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-25T11:40:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":35101,"lastUser":{"userID":35101,"name":"Mikey","url":"https:\/\/community.smartsheet.com\/profile\/Mikey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-01-15T02:43:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":11,"countViews":9379,"score":null,"hot":11,"url":"https:\/\/community.smartsheet.com\/discussion\/5915\/if-status-is-completed-then-make-complete-100","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5915\/if-status-is-completed-then-make-complete-100","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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}">