Multiple checkboxes automatically checked from one checkbox.

GiselleF

Hello,

What formula would I use to have all of the checkboxes in the Ann Arbor Terminal 1-5 columns checked, after checking the prior "Ann Arbor Payment Terminals Inspected" column?

Basically I'd like the checkbox in this column to when checked, trigger the other columns in the same row to be checked (without having to do so manually).

NickStaffordPM

So to do this you would need to use a column formula into each individual Terminal's Column to auto check if the Ann Arbor Payment Terminals Inspected column was checked.

The problem with this is once a column formula is in a column, you are not able to manually change the value. This means that someone will not be able to come in an check just that Terminal 2 individually was completed.

Alternatively, You could have a formula auto checking the Ann Arbor Payment Trminals Inspected column if all those individual columns are checked, that formula would look like this

=IF(AND([Ann Arbor terminal 1]=1,[Ann Arbor terminal 2]=1,[Ann Arbor terminal 3]=1,[Ann Arbor terminal 4]=1,[Ann Arbor terminal 5]=1),1,0).

@ me if I misunderstood!

Andrée Starå

Hi @GiselleF

I hope you're well and safe!

I'd recommend using a workflow with the Change a cell action that triggers when you check the payment box.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

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!