If, And, Or in one formula


Hi all

I am trying to write a formula but I don't know how to use "OR" to accomplish what I need. Here is an outline.

IF Engineering Review Result = "Approved" AND IF Planner Review Result = "Approved", AND IF either (Supplier QA Review Result = "Approved" OR Skip Supplier QA Review is CHECKED), then write "Complete".

I need it to check either that the Supplier QA Review Result says "Approved" or if not, does the Skip Supplier QA Review have a check mark. One or the other must be true but not both.

Here is a working formula without the OR part.

=IF(AND([Engineering Review Result]@row="Approved", [Planner Review Result]@row="Approved", [Supplier QA Review Result]@row="Approved"),"Complete", "Not Complete")

Any help appreciated!


Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    Hey @AJudge

    Try this:

    =IF(AND([Engineering Review Result]@row="Approved", [Planner Review Result]@row="Approved", OR([Supplier QA Review Result]@row="Approved",[Skip Supplier QA Review]@row=1)),"Complete", "Not Complete")

    Does this work for you?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!