At Risk triggered by formula
Hello!! I'm trying to target the "At Risk" column with a formula to "flag" automatically.
I need to have my At Risk flag marked automatically if a task is overdue [End Date] and the [Status] is "Not Started" and "In Progress"
I tried using this formula:
=IF(AND([End Date]@row <= TODAY(), Status@row <> "Not Started" "In Progress"), 1, 0)
I'm getting an #UNPARSEABLE error
Please help,
Thanks!
Best Answers
-
Hello @Estefania Reyes
Please try this:
=IF([End Date]@row = "", "", IF(AND([End Date]@row <= TODAY(), NOT(Status@row = "Complete")), 1, 0)
Frank Smith, PMP
Assistant Director | IT Special Projects Mgr.
Oregon Parks & Recreation Department
If my response helps, please mark it as an accepted answer. 😎
-
Try:
=IF(AND(End@row <= TODAY(), OR(Status@row = "Not Started", Status@row = "In Progress")), 1, 0)
You've almost got it, just need to throw in the OR function to catch both cases of the status.
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
-
Thank you! It worked. :)
Answers
-
Hello @Estefania Reyes
Please try this:
=IF([End Date]@row = "", "", IF(AND([End Date]@row <= TODAY(), NOT(Status@row = "Complete")), 1, 0)
Frank Smith, PMP
Assistant Director | IT Special Projects Mgr.
Oregon Parks & Recreation Department
If my response helps, please mark it as an accepted answer. 😎
-
Hi @Estefania Reyes,
If I've understood correctly, this should be your formula:
=IF(AND([End Date]@row <= TODAY(), OR(Status@row = "Not Started", Status@row = "In Progress")), 1, 0)
If Status is either "Not Started" or "In Progress" and the End Date is equal to or before today, then the box is ticked.
If I've misunderstood some part of this, let me know and I will correct it. If you've any other questions etc. on this, then just post! 😊
-
Try:
=IF(AND(End@row <= TODAY(), OR(Status@row = "Not Started", Status@row = "In Progress")), 1, 0)
You've almost got it, just need to throw in the OR function to catch both cases of the status.
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
-
Thank you! It worked. :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!