Multiple "OR" for single formula?
I have about 14 single choice options in a column that if chosen, lead to a specific Harvey ball status. I've used multiple "Or" entries, and I wonder what I'm leaving out, as it's coming back unparceable. Here's the formula:
=IF(OR([EVAL Stage]2 = "Not Started", [EVAL Stage]2 = "Containment", [EVAL Stage]2 = "Starting Over"), "Empty"), IF(OR( [EVAL Stage]2 = "1. EVAL requested", [EVAL Stage]2 = "2. EVAL reviewed", [EVAL Stage]2 = "3. EVAL accepted"), "Quarter"), IF(OR ([EVAL Stage]2 = "4. Test device ordered", [EVAL Stage]2 = "5. Lab Setup", [EVAL Stage]2 = "6. Testing"), "Half"), IF(OR([EVAL Stage]2 = "7. Seeking Technical Approval", [EVAL Stage]2 = "8. Approval Received", [EVAL Stage]2 = "9. Documentation"), "Three Quarter"), IF(OR([EVAL Stage]2 = "Complete", "Full"))
Best Answers
-
My apologies. I also adjusted your last IF and forgot to point it out. Try the formula from my last comment.
-
Taking an even closer look it appears as if there are some extra spaces throwing things off too. Sorry about that. Here...
=IF(OR([EVAL Stage]2 = "Not Started", [EVAL Stage]2 = "Containment", [EVAL Stage]2 = "Starting Over"), "Empty", IF(OR([EVAL Stage]2 = "1. EVAL requested", [EVAL Stage]2 = "2. EVAL reviewed", [EVAL Stage]2 = "3. EVAL accepted"), "Quarter", IF(OR([EVAL Stage]2 = "4. Test device ordered", [EVAL Stage]2 = "5. Lab Setup", [EVAL Stage]2 = "6. Testing"), "Half", IF(OR([EVAL Stage]2 = "7. Seeking Technical Approval", [EVAL Stage]2 = "8. Approval Received", [EVAL Stage]2 = "9. Documentation"), "Three Quarter", IF([EVAL Stage]2 = "Complete", "Full")))))
Answers
-
Hello @Travis Griffin I think it might be the parentheses after each true option (see below), I believe this is closing the If statement not allowing it to continue it using the false, try putting them at the end instead
Michael
-
You are closing your IF statements too early.
=IF(OR([EVAL Stage]2 = "Not Started", [EVAL Stage]2 = "Containment", [EVAL Stage]2 = "Starting Over"), "Empty", IF(OR( [EVAL Stage]2 = "1. EVAL requested", [EVAL Stage]2 = "2. EVAL reviewed", [EVAL Stage]2 = "3. EVAL accepted"), "Quarter", IF(OR ([EVAL Stage]2 = "4. Test device ordered", [EVAL Stage]2 = "5. Lab Setup", [EVAL Stage]2 = "6. Testing"), "Half", IF(OR([EVAL Stage]2 = "7. Seeking Technical Approval", [EVAL Stage]2 = "8. Approval Received", [EVAL Stage]2 = "9. Documentation"), "Three Quarter", IF([EVAL Stage]2 = "Complete", "Full")))))
-
Thanks. I removed those, and added at the end, still getting "Unparsed"
=IF(OR([EVAL Stage]2 = "Not Started", [EVAL Stage]2 = "Containment", [EVAL Stage]2 = "Starting Over"), "Empty", IF(OR( [EVAL Stage]2 = "1. EVAL requested", [EVAL Stage]2 = "2. EVAL reviewed", [EVAL Stage]2 = "3. EVAL accepted"), "Quarter", IF(OR ([EVAL Stage]2 = "4. Test device ordered", [EVAL Stage]2 = "5. Lab Setup", [EVAL Stage]2 = "6. Testing"), "Half", IF(OR([EVAL Stage]2 = "7. Seeking Technical Approval", [EVAL Stage]2 = "8. Approval Received", [EVAL Stage]2 = "9. Documentation"), "Three Quarter", IF(OR([EVAL Stage]2 = "Complete", "Full"))))))
-
My apologies. I also adjusted your last IF and forgot to point it out. Try the formula from my last comment.
-
It is the last if statement, you have an "or" in there for one criteria
Michael
-
Taking an even closer look it appears as if there are some extra spaces throwing things off too. Sorry about that. Here...
=IF(OR([EVAL Stage]2 = "Not Started", [EVAL Stage]2 = "Containment", [EVAL Stage]2 = "Starting Over"), "Empty", IF(OR([EVAL Stage]2 = "1. EVAL requested", [EVAL Stage]2 = "2. EVAL reviewed", [EVAL Stage]2 = "3. EVAL accepted"), "Quarter", IF(OR([EVAL Stage]2 = "4. Test device ordered", [EVAL Stage]2 = "5. Lab Setup", [EVAL Stage]2 = "6. Testing"), "Half", IF(OR([EVAL Stage]2 = "7. Seeking Technical Approval", [EVAL Stage]2 = "8. Approval Received", [EVAL Stage]2 = "9. Documentation"), "Three Quarter", IF([EVAL Stage]2 = "Complete", "Full")))))
-
Hot Dog. Thank you. That was it. Thanks so much for helping. So new at this.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!