IF Formula using Dropdowns and Checkboxes
Hi, Smartsheet formula novice here! I hope the following will make sense.
I'm attempting to create an IF formula that makes use of two drop down options from 1 column as well as checkboxes from 2 additional columns.
Currently, the below 3 columns must be checked for the 4th column to be checked (starred) off.
=IF([Entered on Homes with Access to Minibus Group]@row = "true", IF(AND([Entered on Home Group]@row = "true", [Home Admin Notified]@row = "true"), true, false), false)
I would like to replace the first column's checkbox with a drop down list (pictured below), with the following conditions required for the fourth column to be checked off:
"Yes" or "No Minibus"
AND
Columns 2 and 3 selected
Many thanks for your time and please do let me know if you require more information.
Best Answer
-
Try something like this:
=IF(AND(OR([Column1]@row = "Yes", [Column1]@row = "No Minibus"), [Column2]@row = 1, [Column3]@row = 1), 1)
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
-
Try something like this:
=IF(AND(OR([Column1]@row = "Yes", [Column1]@row = "No Minibus"), [Column2]@row = 1, [Column3]@row = 1), 1)
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!
-
Thank you, Paul!
-
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
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!