If formula for multiple check boxes.

JoC

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.

Danielle Arteaga

You have an extra comma in your formula before the close parenthesis for the AND

Once you remove that, you should be set!

DKazatsky2

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

JoC

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")

Danielle Arteaga

You have an extra comma in your formula before the close parenthesis for the AND

Once you remove that, you should be set!

JoC

Thank you both!!

Very helpful!