Formula help for At Risk Flag

Tina Conrad

 I want a formula that states if Finish date is less than today and % complete is not full (harvey ball) then color the flag.

This is my formula but it is not coloring the flag for the scenario: Finish date is 4/28/20 and Harvey ball is 3/4.

=IF(AND(Finish@row < TODAY(), [% Complete]@row < 1), 1, 0)

Any guidance would be appreciated.

Thanks

Mark Safran

Hey Tina,

If your % Complete column is set to a Symbol Type (Harvey Ball), the logical expression conditions for that are "Full", "Three-Quarter", "Half", "Quarter", and "Empty". Try this formula:

=IF(AND([Finish]@row < TODAY(), [% Complete]@row <> "Full"), 1)

-MS

Tina Conrad

Mark, thank you that worked.

Thank you Antonio also.

Antonio Neto

Formulas with symbols should use the name of the symbol.

See if this solves your issue:

=IF(AND(Finish@row < TODAY(), [% Complete]@row <> "Full"), 1, 0)

Mark Safran

Hey Tina,

If your % Complete column is set to a Symbol Type (Harvey Ball), the logical expression conditions for that are "Full", "Three-Quarter", "Half", "Quarter", and "Empty". Try this formula:

=IF(AND([Finish]@row < TODAY(), [% Complete]@row <> "Full"), 1)

-MS

Tina Conrad

Mark, thank you that worked.

Thank you Antonio also.