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)))
Help Article Resources
Check out the Formula Handbook template!