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

Answers

  • Brian Campbell
    Brian Campbell ✭✭✭✭✭
    edited 07/31/20

    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

  • Paul Newcome
    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")))))

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

  • Brian Campbell
    Brian Campbell ✭✭✭✭✭

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

    Michael

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!