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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!