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.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!