At Risk Flag
Hello All,
I'm trying to enable an at risk flag with the following criteria:
- Within 3 days of date to follow up
- if the status is either "open" or "deferred"
- ignoring any rows that have blanks for dates
I've been searching the forum, I found one that worked, but flagged every empty row at risk because there were zero entries (this populates from a form, so I don't want to count any blanks).
Here's an example of one of the formulas I was trying.
Best Answer
-
Give this a try:
=IF(ISDATE([Date to follow up]@row), IF(OR([Status for SOX]@row = "Open", [Status for SOX]@row = "Deferred"), IF([Date to follow up]@row <= TODAY(3), 1, 0)), "")
Answers
-
Give this a try:
=IF(ISDATE([Date to follow up]@row), IF(OR([Status for SOX]@row = "Open", [Status for SOX]@row = "Deferred"), IF([Date to follow up]@row <= TODAY(3), 1, 0)), "")
-
Perfect! Thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 429 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!