Determining if all check boxes are checked.

rwcanary99

How do you write a function to see if all boxes are checked on a row with multiple checkboxes?

I tried using the SUMIF(Check_Box_1@Row = 1) and attempted to use a total number of checks to evaluate, but it does not like that. I tried using IF((checkbox=1 AND Checkbox2=1),"true","false)

But that concept did not work either.

Andrée Starå

Hi @rwcanary99

I hope you're well and safe!

You'd use something like this.

=IF(COUNTIFS(ColumnNameA@row:ColumnNameE@row, <>"") = 9, 1)

Did that work/help?

I hope that helps!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

rwcanary99

Thanks

rwcanary99

Oopps I spoke too soon.

Spoke too soon.

It didn't work; it gave a "1," regardless of whether the box was checked.

My solution is rather wordy:

=IF(AND(

OR([In Place]@row = 1, [In Place]@row = "NA"), 

OR([CNTL Conduit]@row = 1, [CNTL Conduit]@row ="NA"),

OR([CNTL Bushing]@row = 1, [CNTL Bushing]@row ="NA"),

OR([CNTL Wire Pulled]@row = 1, [CNTL Wire Pulled]@row ="NA"),

OR([CNTL Wire Terminated]@row = 1, [CNTL Wire Terminated]@row ="NA"),

OR([CNTL Wire Labels]@row = 1, [CNTL Wire Labels]@row ="NA"),

OR([ENET Conduit]@row = 1, [ENET Conduit]@row ="NA"),

OR([ENET Bushing]@row = 1, [ENET Bushing]@row ="NA"),

OR([ENET Pulled]@row = 1, [ENET Pulled]@row ="NA"),

OR([ENET Terminated]@row = 1,[ENET Terminated]@row ="NA"),

OR([ENET Label]@row = 1, [ENET Label]@row ="NA"),

OR([PWR Conduit]@row = 1, [PWR Conduit]@row ="NA"),

OR([PWR Bushing]@row = 1, [PWR Bushing]@row ="NA"),

OR([PWR Wire Pulled]@row = 1, [PWR Wire Pulled]@row ="NA"),

OR([PWR Terminated]@row = 1, [PWR Terminated]@row ="NA"),

OR([PWR Labeled]@row = 1, [PWR Labeled]@row ="NA")

)

,"Comp", "InComp"

)

Andrée Starå

@rwcanary99

Happy to help!

Try this.

=IF(COUNTIFS([In Place]@row:[PWR Labeled]@row, <>"") = 16, 1)

Did that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!