If Complete box is checked can multiple check box columns be AUTO checked?

Tammy Parker

I have a complete column with a check box - and several additional action items needed for each row. Many times multiple things happen at once...

IF the complete box is checked can ALL columns with check boxes be AUTO checked also????

Maddie Simonsen

You can add a formula to the other check box columns that's =if([Complete]@row=1,1)

Just change the "Complete" thats in these brackets to whatever the name of your column is for the complete column.

You will still be able to check off the non-complete check boxes manually - when you check it off manually the formula will go away.

Maddie

Tammy Parker

Thank you!! I was making it too difficult, trying to do them all... LOL That was too easy... LOL

Maddie Simonsen

You can add a formula to the other check box columns that's =if([Complete]@row=1,1)

Just change the "Complete" thats in these brackets to whatever the name of your column is for the complete column.

You will still be able to check off the non-complete check boxes manually - when you check it off manually the formula will go away.

Maddie

Tammy Parker

Thank you!! I was making it too difficult, trying to do them all... LOL That was too easy... LOL

Maddie Simonsen

happy to help!!