At Risk Flag
Options
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!