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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Yes that worked! Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!