INVALID OPERATIONS Error

billie.kline49421

Looking for some help to resolve this error message. This formula works when I split it out, but when I put it together I am getting this invalid operations error.

=IF(Status@row = "Complete", "Blue", IF(Status@row = "On-hold", "-", IF(Status@row = "FYI", "-", IF(Status@row = "Withdrawn", "-", IF(AND(Finish@row > TODAY(-1), (Status@row = "In-Progress")), "Green", =IF(AND(Status@row = "Not Started", Start@row > TODAY()), "-", IF(AND(Status@row = "Not Started", Start@row = ""), "-", "Yellow")))))))

Appreciate help to resolve.

Billie

Update: You can disregard this question. I just found my error. I had an inappropriate "=IF". I guess after a while your eyes just go batty.

Genevieve P.

Hi @billie.kline49421

I'm glad you found the error and were able to resolve this! It was a very small detail, well-spotted.

Cheers,

Genevieve