How to use IF function with AND OR

I am trying to establish a workflow based on the approval of several stakeholders. There are 8 stakeholders (contact column type) and not all will be required to review/approve. If the stakeholders approve the change the project sponsor will be required to approve. I intend to have a workflow for each stakeholder to "approve" or "decline". If no stakeholder is identified the row is to be filled "not applicable". How do I write the if statement to include a summarizing column of stakeholders approval based on each stakeholders assessment.

I have tried starting with the logic for 1 stakeholder and then expanding for all but I am not having any success at step 1. Here is my initial calc:

=IF(OR([Stakeholder 1 approval]7 = "Approved", [Stakeholder 1 approval]7 = "Not Applicable", "Approved", "Declined"))

any tips for someone new to Smartsheet?

Find more posts tagged with

Accepted answers

Jason Albrecht

Hi @deej

Looking only at the initial calc, I suspect the closing bracket for the OR function should be between Not Applicable and Approved - like this:

=IF(OR([Stakeholder 1 approval]7 = "Approved", [Stakeholder 1 approval]7 = "Not Applicable"), "Approved", "Declined")

deej

I forgot the comma between )) and "Approved" towards the end.

=IF(AND(OR([Stakeholder 1 approval]8 = "Approved", [Stakeholder 1 approval]8 = "Not Applicable"),OR([Stakeholder 2 approval]8 = "Approved", [Stakeholder 2 approval]8 = "Not Applicable")), "Approved", "Declined")

this seems to work. thanks for your guidance!

All comments

Jason Albrecht

Hi @deej

Looking only at the initial calc, I suspect the closing bracket for the OR function should be between Not Applicable and Approved - like this:

=IF(OR([Stakeholder 1 approval]7 = "Approved", [Stakeholder 1 approval]7 = "Not Applicable"), "Approved", "Declined")

deej

Thank you, works perfectly. How would you suggest stringing together multiple stakeholders? I am trying using the AND statement but again not having much luck.

deej

I forgot the comma between )) and "Approved" towards the end.

this seems to work. thanks for your guidance!

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.