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?
Best Answers
-
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")
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile - Open to work
-
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!
Answers
-
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")
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile - Open to work
-
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.
=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")
-
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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 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!