Automating at Risk Flag
Hi All,
I'm a total newbie to Smartsheets and need some help.
I'm trying to automate my At Risk Flag. I need it to flag projects a month from their due date if they are 50% or less complete.
Thank you!
Best Answer
-
Paul Newcome ✭✭✭✭✭✭Try something like this...
=IF(AND([Due Date]@row <= TODAY(30), [% Complete]@row <= .5), 1)
只要确保你改变列名世界卫生大会tever you are using in your sheet.
Answers
-
Paul Newcome ✭✭✭✭✭✭
Try something like this...
=IF(AND([Due Date]@row <= TODAY(30), [% Complete]@row <= .5), 1)
只要确保你改变列名世界卫生大会tever you are using in your sheet.
Help Article Resources
Categories
Check out theFormula Handbook template!
Hi @ECRCalexandra<\/a>, <\/p> If you're not wanting to flag the non-PD lines, then use something along the lines of this:<\/p> =IF(AND(Notes@row = \"PD\", COUNTIFS(Notes:Notes, \"PD\", [Date 1]:[Date 1], [Date 1]@row, Platform:Platform, Platform@row, Platform:Platform, \"online\") > 1), 1, 0)<\/p> This does the checks, but makes sure the line is PD before ticking\/not.<\/p> Hope this helps, but if you've any problems\/questions or I've misunderstood something then just post! 🙂<\/span><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":111950,"type":"question","name":"Using COUNTIF(S) with RIGHT functionality","excerpt":"Hello! We have a record ID number that includes text. The first handful of records were entered manually for historical purposes. Now, records coming through the Smartsheet intake form are automated to begin with the number 100. For the dashboard, I'm looking to only count records with an ID greater than 100. This doesn't…","snippet":"Hello! We have a record ID number that includes text. The first handful of records were entered manually for historical purposes. Now, records coming through the Smartsheet intake…","categoryID":322,"dateInserted":"2023-10-20T13:05:21+00:00","dateUpdated":null,"dateLastComment":"2023-10-20T13:46:21+00:00","insertUserID":165889,"insertUser":{"userID":165889,"name":"mónicas","url":"https:\/\/community.smartsheet.com\/profile\/m%C3%B3nicas","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-20T14:11:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":151203,"lastUser":{"userID":151203,"name":"Nick Korna","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Korna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-20T14:33:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":21,"score":null,"hot":3395618502,"url":"https:\/\/community.smartsheet.com\/discussion\/111950\/using-countif-s-with-right-functionality","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/111950\/using-countif-s-with-right-functionality","format":"Rich","lastPost":{"discussionID":111950,"commentID":400924,"name":"Re: Using COUNTIF(S) with RIGHT functionality","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/400924#Comment_400924","dateInserted":"2023-10-20T13:46:21+00:00","insertUserID":151203,"insertUser":{"userID":151203,"name":"Nick Korna","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Korna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-20T14:33:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-20T13:38:04+00:00","dateAnswered":"2023-10-20T13:26:51+00:00","acceptedAnswers":[{"commentID":400907,"body":"
