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"))
Best Answer
-
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.
Answers
-
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
Help Article Resources
Categories
Check out the Formula Handbook template!
