IF/OR Formula Error

I created a formula to populate a field based on the status of various other fields. I got it to work with two conditions (Approved or Declined), but when I add the third (Submitted) with the false response of blank (""), I get an error. Please see the formula below - I assume I messed up something really easy :)

=IF(OR([Sales Leader (Requester) Approval Status]@row = "Approved", [ADL PL Approval Status]@row = "Approved", [Consulting PL Approval Status]@row = "Approved", [Centurion PL Approval Status]@row = "Approved", [TCAS Approval Status]@row = "Approved", [VB Approval Status]@row = "Approved"), "Approved", IF(OR([Sales Leader (Requester) Approval Status]@row = "Declined", [ADL PL Approval Status]@row = "Declined", [Consulting PL Approval Status]@row = "Declined", [Centurion PL Approval Status]@row = "Declined", [TCAS Approval Status]@row = "Declined", [VB Approval Status]@row = "Declined"), "Declined"), IF(OR([Sales Leader (Requester) Approval Status]@row = "Submitted", [ADL PL Approval Status]@row = "Submitted", [Consulting PL Approval Status]@row = "Submitted", [Centurion PL Approval Status]@row = "Submitted", [TCAS Approval Status]@row = "Submitted", [VB Approval Status]@row = "Submitted")))

Tags:

Best Answer

  • markkrebs
    markkrebs ✭✭✭✭✭✭
    Answer ✓

    =IFERROR(IF(OR([1]@row = "Approved", [2]@row = "Approved", [3]@row = "Approved", [4]@row = "Approved", [5]@row = "Approved", [6]@row = "Approved"), "Approved", IF(OR([1]@row = "Declined", [2]@row = "Declined", [3]@row = "Declined", [4]@row = "Declined", [5]@row = "Declined", [6]@row = "Declined"), "Declined", IF(OR([1]@row = "Submitted", [2]@row = "Submitted", [3]@row = "Submitted", [4]@row = "Submitted", [5]@row = "Submitted", [6]@row = "Submitted"), "submitted"))), "bad")


    You forgot the value of "submitted" at the end and had a ) issue too. hopefully this works for you

Answers

  • markkrebs
    markkrebs ✭✭✭✭✭✭
    Answer ✓

    =IFERROR(IF(OR([1]@row = "Approved", [2]@row = "Approved", [3]@row = "Approved", [4]@row = "Approved", [5]@row = "Approved", [6]@row = "Approved"), "Approved", IF(OR([1]@row = "Declined", [2]@row = "Declined", [3]@row = "Declined", [4]@row = "Declined", [5]@row = "Declined", [6]@row = "Declined"), "Declined", IF(OR([1]@row = "Submitted", [2]@row = "Submitted", [3]@row = "Submitted", [4]@row = "Submitted", [5]@row = "Submitted", [6]@row = "Submitted"), "submitted"))), "bad")


    You forgot the value of "submitted" at the end and had a ) issue too. hopefully this works for you

  • Tony Fronza
    Tony Fronza ✭✭✭✭

    Thank you @markkrebs ! That worked perfectly.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!