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?
Help Article Resources
Check out the Formula Handbook template!