Why do I get a #Incorrect argument set error with the formula below/
Carole M.
✭✭
=IF(Status@row = "Not Started", "Blue", IF(OR(AND(TODAY()>[End Date]@row, Status@row = "Not Started"), AND(TODAY()>[End Date]@row, Status@row = "In Progress")), "Red", IF(OR(AND(TODAY(-5)>[End Date]@row, Status@row = "Not Started"), AND(TODAY(-5)>[End Date]@row, Status@row = "In Progress")), "Yellow", IF(Status@row = "Complete", "Green")))))
Best Answers
-
14 opening parentheses, 15 closing parentheses.
-
It's an easy mistake to make. Glad I could help.
Answers
-
14 opening parentheses, 15 closing parentheses.
-
Got it, thanks!
-
It's an easy mistake to make. Glad I could help.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives