# Can you help me figure out what is causing the Invalid Operation Error for this formula?

=IF(AND(Finish@row < TODAY() >= Finish@row, [% Complete]@row < 1), "Red", IF(AND(Finish@row < TODAY(-3), [% Complete]@row < 0.99), "Yellow", "Green"))

• ✭✭✭✭✭✭

It is going to be in the first AND statement. You need to break the date portion down into two separate arguments.

=IF(AND(Finish@row < TODAY() >= Finish@row, [% Complete]@row < 1), "Red", IF(AND(Finish@row < TODAY(-3), [% Complete]@row < 0.99), "Yellow", "Green"))

The way you currently have it written though, your two separate arguments would be that Finish is "less than" today and Finish is "less than or equal to" today which you may as well just say the second.

• ✭✭✭✭✭✭

It is going to be in the first AND statement. You need to break the date portion down into two separate arguments.

=IF(AND(Finish@row < TODAY() >= Finish@row, [% Complete]@row < 1), "Red", IF(AND(Finish@row < TODAY(-3), [% Complete]@row < 0.99), "Yellow", "Green"))

The way you currently have it written though, your two separate arguments would be that Finish is "less than" today and Finish is "less than or equal to" today which you may as well just say the second.

• Thanks Paul. I

• ✭✭✭✭✭✭

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!