Help with Parent Check Box and Children Aligning

cferias

Hello, I am trying to get he children to automatically be checked when the parent is checked off. I was trying to get a helper column to assist, but something is just not clicking in my head to make this work!

Razetto

@cferias Try this formula in the capa column and see if it works =IF(PARENT() = 1, 1, 0)

cferias

Hi - thank you @Razetto ! But i want to make it a column formula and if i do that then i will no longer be able to actually "check off" the parent row.

jmyzk_cloudsmart_jp

Hi @cferias

If you are ok with separate checkbox columns for parents and children, here is a column formula;😀

=IF(NOT(isParent@row), IF(PARENT([Parent Checkbox]@row), 0, 1))

https://app.smartsheet.com/b/publish?EQBCT=f5515795424846299edeac8885623991

The formula un-checks the children's checkbox when the parent checkbox is checked.