Helper Column: Checkbox Children from Checkbox Parent
I am trying to build the formula for a helper column that will check all the checkboxes of the children rows if the parent row has the checkbox checked. The formula works but it outputs "true" or "false". Is there anyway it can be checkboxes? I have a helper column called "Level" with parents as Level=0.
=IF(Level@row > 0, JOIN(COLLECT(ANCESTORS(Checkbox Column@row), ANCESTORS(Level@row), 0)))
Best Answer
-
yes i did change it to a text box column and it was still not working. i used a different formula and got a better result:
=IFERROR(INDEX(ANCESTORS(Checkbox Column@row), 1), Checkbox Column@row)
Answers
-
Have you set the column type to be a checkbox type column?
-
yes i did change it to a text box column and it was still not working. i used a different formula and got a better result:
=IFERROR(INDEX(ANCESTORS(Checkbox Column@row), 1), Checkbox Column@row)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!