Formula has to meet one criteria, other two criteria is optional
ss1992
✭✭
Hello,
I am stumped with a IF OR smartsheet formula:
I need a formula to tell me if Cell 1 = "Yes", and EITHER, Cell 2 and 3 = "Yes", then return "action" otherwise "no action:
So the criteria is cell 1 has to be yes. If it's no, it won't be considered.
Criteria for cell 2 & 3 is that either one of them could be yes
Example of what should happen:
Cell 1: Yes
Cell 2: No
Cell 3: Yes
Formula should return "action"
Best Answer

Hi @ss1992,
Try this
=IF(AND([1]@row = "Yes", OR([2]@row = "Yes", [3]@row = "Yes")), "action", "")
Hope that helps!
BRgds,
Ray
Answers

Hi @ss1992,
Try this
=IF(AND([1]@row = "Yes", OR([2]@row = "Yes", [3]@row = "Yes")), "action", "")
Hope that helps!
BRgds,
Ray

Thank you @Ray Lindstrom this worked!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 348 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 Events
 36 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!