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!
AJ
Best 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?
Kelly
Answers
-
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?
Kelly -
Great this works perfectly! Thank you for your help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!