Conditional formatting on checkbox column

User251

is there a way to set conditional formatting on a checkbox column so that if the children's rows are checked, the parent row is automatically checked?

Mike TV

Here's a tricky one. It's not exactly the way you asked for it to be done but this is what I came up with:

Child Checked column formula:

=JOIN(CHILDREN(Checkmark@row), " ")

Setup an automation:

The parent row in the Checkmark column was able to be checkmarked automatically using this method.

Mike TV

Here's a tricky one. It's not exactly the way you asked for it to be done but this is what I came up with:

Child Checked column formula:

=JOIN(CHILDREN(Checkmark@row), " ")

Setup an automation:

The parent row in the Checkmark column was able to be checkmarked automatically using this method.

User251

Thank you so much @Matt C. !!! The only change that I needed to make to make sure that the parent is only checked when all children are checked is to change the condition to "does not contain" false.

Thanks again for your help!

Mike TV

Glad that worked. Ya, I wasn't sure if you needed the parent checked if any of the children were checked or if all of them. I'm glad you figured that part out. Have a fantastic day!