Can someone tell me what I am doing wrong in this formula?

System

This discussion was created from comments split from: Formula that compares one cell to another.

jtw1111

Can someone tell me what I am doing wrong in this formula? =IF([Estimated or Actual Finish]@row>Finish@row), "Yellow", IF(AND([% Complete]15 < 1, Finish@row < TODAY()), "Red", "Green")

Sam_Harwart

Hi @jtw1111 ,

There's an extra parentheses. Once you remove that, the formula looks good.

jtw1111

Still UNPARSEABLE