INVALID OPERATIONS Error
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.
Comments
-
I'm glad you found the error and were able to resolve this! It was a very small detail, well-spotted.
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!