Helper Column: Checkbox Children from Checkbox Parent

Options

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

  • cn13218
    cn13218 ✭✭
    Answer ✓
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!