Help with Parent Check Box and Children Aligning
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!
Tags:
Answers
-
@cferias Try this formula in the capa column and see if it works =IF(PARENT() = 1, 1, 0)
-
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.
-
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))
The formula un-checks the children's checkbox when the parent checkbox is checked.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!