I need help with At Risk Formula
I am trying to have the at risk flag appear when the following conditions apply:
Status is : Comment Resolution, Not Started, Draft, NVX Review/ Comments
Due Date is less than 10 days away
I was playing around and got this far but its not working
=IF(OR(Status@row <> "Not Started", Status@row <> "Draft", Status@row <> "NVX Review/ Comments", Status@row <> "Comment Resolution"), 0, IF(AND([Due Date ]@row <=(Today)10, [Due Date]@row >=Today() 1, 0))
Answers
-
Snapshot for reference
-
What is the list of all of the possible statuses?
-
Comment Resolution, Not Started, Draft, NVX Review/ Comments
& Doc. Effective which obviously wouldn't apply
-
Ok. In that case we could just say "if the status is Doc. Effective" instead of "if the status is not one of these 4 things.
IF(AND([Due Date]@row <= TODAY(10), [Due Date]@row >= TODAY(), Status@row = "Doc. Effective"), 1)
Your original formula would still work except for a few syntax issues. It looks like you may have some extra spaces in some column names, a missing comma, and a few parenthesis need moved around.
=IF(OR(Status@row <> "Not Started", Status@row <> "Draft", Status@row <> "NVX Review/ Comments", Status@row <> "Comment Resolution"), 0, IF(AND([Due Date]@row <= TODAY(10), [Due Date]@row >= TODAY()), 1, 0))
-
Still not working
-
Which one is not working and is it outputting an error or an unexpected output?
The shorter formula above says:
IF Due Date is less than or equal to today + 10 AND Due Date is greater than or equal to today AND Status is not "Doc. Effective" then flag the row.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!