Automate At Risk Flag

erayer · 05/22/23

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!

Genevieve P. · 05/23/23

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

Hollie Green · 05/22/23

=IF(AND([% Complete]@row < "1", [Target Date]@row <= TODAY()), true)

erayer · 05/22/23

I am receiving "Invalid" with the formula above.

erayer · 05/22/23

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?

Genevieve P. · 05/23/23

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

erayer · 05/23/23

Yes that worked! Thank you!

Formulas and Functions