Formula to check a box when specific criteria are met
Hi! I am looking for a formula to check a box when specific criteria are met. I have multiple columns that have dropdown options. I would like the box to check when each of those columns have either "Approved" or "Declined" selected. But if "Submitted" is the option shown, then it should not check the box.
So all columns/cells should have either "Approved" or "Declined", and only when all of the columns have one of these selected, then the box is checked.
Any help is appreciated!
Best Answer
-
Hi @JessZwei,
Give this a try.
=IF(AND(OR([QA Request Status]@row = "Approved", [QA Request Status]@row = "Declined"), OR([QC Request Status]@row = "Approved", [QC Request Status]@row = "Declined")), 1)
Hope this helps,
Dave
Answers
-
Hi @JessZwei,
Give this a try.
=IF(AND(OR([QA Request Status]@row = "Approved", [QA Request Status]@row = "Declined"), OR([QC Request Status]@row = "Approved", [QC Request Status]@row = "Declined")), 1)
Hope this helps,
Dave
-
That's it! Thank you so much, works perfectly!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!