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!
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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!