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

Find more posts tagged with

Formulas

Accepted answers

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

All comments

markkrebs

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.