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")))
Best 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
-
=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
-
Thank you @markkrebs ! That worked perfectly.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!