If formula for multiple check boxes.
I have multiple columns with check boxes and I need a new column that validates if ALL are checked. I'm trying to create a formula that says:
if column 2 is checked,
AND column 3 is checked,
AND column 4 is checked, 'yes' else 'no'.
Any help is appreciated.
Best Answer

You have an extra comma in your formula before the close parenthesis for the AND
Once you remove that, you should be set!
Answers

Hi @JoC ,
Give this a try.
=IF(AND([Column 2]@row = 1, [Column 3]@row = 1, [Column 4]@row = 1), "Yes", "No")
Hope this helps,
Dave

Hi Dave,
That formula gives me an unparseable error. This is my exact formula:
=IF(AND([Ops_Revision Complete 1]@row = 1, [Ops_Revision Complete 2]@row = 1, [Ops_Revision Complete 3]@row = 1, [Ops_Revision Complete 4]@row = 1,), "yes", "no")

You have an extra comma in your formula before the close parenthesis for the AND
Once you remove that, you should be set!

Thank you both!!
Very helpful!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 325 Global Discussions
 183 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!