Conditional formatting on checkbox column

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?

Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    edited 04/28/22 Answer ✓

    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.

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    edited 04/28/22 Answer ✓

    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
    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
    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!