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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!