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

Kate Hazelton

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

Paul Newcome

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.

Paul Newcome

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.

Kate Hazelton

Thanks Paul. I

Paul Newcome

Happy to help. 👍️