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
Check out the Formula Handbook template!