IF/OR Formula Error

Tony Fronza

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

markkrebs

=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

markkrebs

=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

Thank you @markkrebs ! That worked perfectly.