Can someone tell me what I am doing wrong in this formula to set the status ball color?

jtw1111

=IF([Estimated or Actual Finish]@row>Finish@row), "Yellow", IF(AND([% Complete] < 1, Finish@row < TODAY()), "Red", "Green")

Paul Newcome

Try this:

=IF([Estimated or Actual Finish]@row>Finish@row, "Yellow", IF(AND([% Complete]@row < 1, Finish@row < TODAY()), "Red", "Green"))

James Keuning

[% Complete]15

take off that 15?

jtw1111

Still shows as UNPARSEABLE

Paul Newcome

Try this:

=IF([Estimated or Actual Finish]@row>Finish@row, "Yellow", IF(AND([% Complete]@row < 1, Finish@row < TODAY()), "Red", "Green"))

jtw1111

That did it! Thanks.

Paul Newcome

Happy to help. 👍️