Formula help for At Risk Flag

Question

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 · Accepted Answer

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 · Accepted Answer

Mark, thank you that worked.

Thank you Antonio also.