Multiple "OR" for single formula?

Travis Griffin

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"))

Paul Newcome

My apologies. I also adjusted your last IF and forgot to point it out. Try the formula from my last comment.

Paul Newcome

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")))))

Brian Campbell

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

Paul Newcome

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")))))

Travis Griffin

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"))))))

Paul Newcome

My apologies. I also adjusted your last IF and forgot to point it out. Try the formula from my last comment.

Brian Campbell

It is the last if statement, you have an "or" in there for one criteria

Paul Newcome

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")))))

Travis Griffin

Hot Dog. Thank you. That was it. Thanks so much for helping. So new at this.

Paul Newcome

Happy to help. 👍️