探索。问。回答

TODAY(), \"Green\", IF(AND([End Date]@row <= TODAY(), [Start Date]@row < TODAY()), \"Red\", IF(NOT([Start Date]@row > TODAY(+7)), \"Yellow\", IF([Start Date]@row <= TODAY(), \"Green\"))))) Works great! I would…","categoryID":322,"dateInserted":"2022-10-18T21:51:23+00:00","dateUpdated":"2022-10-18T21:53:48+00:00","dateLastComment":"2022-10-21T17:50:49+00:00","insertUserID":153319,"insertUser":{"userID":153319,"name":"rachkh","url":"https:\/\/community.smartsheet.com\/profile\/rachkh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T18:09:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":153319,"lastUserID":153319,"lastUser":{"userID":153319,"name":"rachkh","url":"https:\/\/community.smartsheet.com\/profile\/rachkh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T18:09:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":79,"score":null,"hot":3332510532,"url":"https:\/\/community.smartsheet.com\/discussion\/96758\/scheduled-health-rollup-using-red-yellow-green-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96758\/scheduled-health-rollup-using-red-yellow-green-formula","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-18T22:48:51+00:00","dateAnswered":"2022-10-18T22:30:59+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":[],"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":96837,"type":"question","name":"At Risk Formula that utilizes end date and status columns only...","excerpt":"I am stumped. I have tried various formulas only for them to error. The closest I have come is the following but I am missing pieces. =IF([End Date]@row = \"\", 0, IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1)) BUT... I need it to do more: I need it to NOT USE % Complete I need it to flag at least 14 days prior…","categoryID":322,"dateInserted":"2022-10-20T16:01:19+00:00","dateUpdated":"2022-10-20T16:18:28+00:00","dateLastComment":"2022-10-21T17:50:49+00:00","insertUserID":153939,"insertUser":{"userID":153939,"name":"StephMac","url":"https:\/\/community.smartsheet.com\/profile\/StephMac","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5qva-T3_fr4!XENa3xHiAXw!_A8YbuSviJk","dateLastActive":"2022-10-21T15:53:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":153939,"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":"2022-10-21T17:57:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":43,"score":null,"hot":3332659928,"url":"https:\/\/community.smartsheet.com\/discussion\/96837\/at-risk-formula-that-utilizes-end-date-and-status-columns-only","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96837\/at-risk-formula-that-utilizes-end-date-and-status-columns-only","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-10-21T14:11:44+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":213,"urlcode":"Conditional Formatting","name":"Conditional Formatting"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":333,"urlcode":"Workflows in Smartsheet","name":"Workflows in Smartsheet"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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":96851,"type":"question","name":"Editor Can Share - Tablet Only Giving Him View Access","excerpt":"Good afternoon, We have a Manager In Training responsible for filling out a daily report. He is shared as an Editor Can Share to the sheet and the report. He is one of three Managers IN training and the other two MITS tablets are working correcty. On his tablet it is \"View Only\" and will not let him edit anything, it also…","categoryID":321,"dateInserted":"2022-10-20T19:27:38+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T17:46:28+00:00","insertUserID":77531,"insertUser":{"userID":77531,"name":"BESP10","url":"https:\/\/community.smartsheet.com\/profile\/BESP10","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu00lQ8zR_XxHSh07OtCCNOCHbxYdJ9xsjCZSkwW=s96-c","dateLastActive":"2022-10-21T17:48:23+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":"2022-10-21T17:57:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":23,"score":null,"hot":3332670846,"url":"https:\/\/community.smartsheet.com\/discussion\/96851\/editor-can-share-tablet-only-giving-him-view-access","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96851\/editor-can-share-tablet-only-giving-him-view-access","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-10-21T15:30:18+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[],"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}">