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
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!