公式

= TODAY(+3), [Due Date]1 < TODAY(+7)), \"Yellow\", IF([Due Date]1 >= TODAY(+7), \"Green\", \"Nope\")))) What im having an issue with is whenever the cell in the due…","categoryID":322,"dateInserted":"2018-12-14T13:51:51+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-20T09:25:31+00:00","insertUserID":68986,"insertUser":{"userID":68986,"name":"rmpedro68986","url":"https:\/\/community.smartsheet.com\/profile\/rmpedro68986","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-12-14T13:37:47+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":2,"countViews":304,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/37541\/ryg-ball-based-on-due-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/37541\/ryg-ball-based-on-due-dates","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-12\/67\/fd\/67fdf39570d462235ecb7ae975229471.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"smartsheet RYG Ball.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"},{"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":37916,"type":"discussion","name":"Sum the number of Grandchildren check boxes","excerpt":"Hi all! I'm trying to figure out the formula for how to sum the number of check boxes from the parents. I have the children figured out but it is the summing of the parents that isn't working. (See Picture) I would expect the Retail line to say 3 instead of zero. The formula that I thought would work is =\"\" +…","categoryID":322,"dateInserted":"2018-12-20T04:30:41+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-20T08:20:23+00:00","insertUserID":73156,"insertUser":{"userID":73156,"name":"CDub","url":"https:\/\/community.smartsheet.com\/profile\/CDub","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-12-20T04:22:08+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-14T13:13:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":76,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/37916\/sum-the-number-of-grandchildren-check-boxes","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/37916\/sum-the-number-of-grandchildren-check-boxes","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-12\/5d\/6e\/5d6eb9f4348d634721ba88ef161e2b59.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet Picture.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":37396,"type":"discussion","name":"Automatically set a date based on a checkbox","excerpt":"I want to be able to automatically set a due date of the next day based on a 2 criteria 1) a check box is checked, and 2) a cell having text in it. For example (we do cabinet installations)...A check box for \"repair doors needed\" is checked, AND \"Repair door sizes to order\" cell has text in it. When those 2 criteria are…","categoryID":322,"dateInserted":"2018-12-13T15:45:21+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-20T06:43:39+00:00","insertUserID":50951,"insertUser":{"userID":50951,"name":"steve50951","url":"https:\/\/community.smartsheet.com\/profile\/steve50951","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-07-16T18:38: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-14T13:06:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":810,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/37396\/automatically-set-a-date-based-on-a-checkbox","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/37396\/automatically-set-a-date-based-on-a-checkbox","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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">