Embedded IF(AND(OR Function Help
Hello,
I have three columns in my sheet each with dropdowns including a "Complete" - type answer and a "Not Required". In the fourth column, I am trying to write a formula to show when the row is 'good to go' - such that all three columns read either "Complete" or "Not required".
I've tried to do this by embedding an "OR" statement within an "AND" statement, but I'm sure this is the right logic. I could create three intermediate columns to process this, but I'd rather do it all in one formula if possible.
Here's what I've attempted, where I want it to print "Y" if we are 'good to go' and "N" if not.
=IF(AND(OR([Column1]@row = "Complete", [Column1]@row = "Not Required"), OR([Column2]@row = "Complete", [Column2]@row = "Not Required"), OR([Column3]@row = "Received", [Column3]@row = "Not Required"), "Y", "N"))
If anyone has any tips it would be greatly appreciated!!
Best Answer
-
Your formula should work with only moving one of the closing parenthesis...
=IF(AND(OR([Column1]@row = "Complete", [Column1]@row = "Not Required"), OR([Column2]@row = "Complete", [Column2]@row = "Not Required"), OR([Column3]@row = "Received", [Column3]@row = "Not Required")), "Y", "N")
You closed off the last OR but forgot to close off the AND before moving to the "output if true" portion of the IF.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Your formula should work with only moving one of the closing parenthesis...
=IF(AND(OR([Column1]@row = "Complete", [Column1]@row = "Not Required"), OR([Column2]@row = "Complete", [Column2]@row = "Not Required"), OR([Column3]@row = "Received", [Column3]@row = "Not Required")), "Y", "N")
You closed off the last OR but forgot to close off the AND before moving to the "output if true" portion of the IF.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Ah thank you @Paul Newcome! Glad that I was on the right track, I appreciate you looking closely to find my mistake!
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!