Automate At Risk Flag
Hello,
I am trying to automate an at-risk flag where the flag will turn red if the item is not 100% complete at the targeted due date.
Any Suggestions?
Thanks!
Best Answer
-
Hey @erayer
A blank date cell is seen as "in the past", which is why you're seeing the flag.
Try this:
=IF([Target Date]@row = "", 0, IF(AND([Target Date]@row < TODAY(), [% Complete]@row < 1), 1))
Cheers,
Genevieve
Answers
-
=IF(AND([% Complete]@row < "1", [Target Date]@row <= TODAY()), true)
-
I am receiving "Invalid" with the formula above.
-
I am getting the flag to trigger on the following formula:
=IF(AND([Target Date]@row < TODAY(), [% Complete]@row < 1), 1)
Only problem is the flag is also triggered when there is no date inputted in the target date section.
Any thoughts?
-
Hey @erayer
A blank date cell is seen as "in the past", which is why you're seeing the flag.
Try this:
=IF([Target Date]@row = "", 0, IF(AND([Target Date]@row < TODAY(), [% Complete]@row < 1), 1))
Cheers,
Genevieve
-
Yes that worked! Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!