Formula help for At Risk Flag
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.
Help Article Resources
Check out the Formula Handbook template!