Check Boxes with Parent / Child Rows

Options

Is there a way or a formula that can be used that if a check box is checked on a parent row, that all the checkboxes in the Child Rows are automatically checked as well?

Best Answer

  • Jon Mark H
    Jon Mark H ✭✭✭✭✭
    Answer ✓
    Options

    Assuming you want to be able to check & uncheck that parent checkbox at will, I would do the following:


    1.)Create a helper column with a formula which tells if each row is a parent or a child, and if it's a child - is its parent's checkbox checked? (see below)

    2.)Then Run an automation which triggers when the helper column changes to "True", it checks your Checkbox column.


    EXAMPLE:

    Here's what I did:

    1.) Created a helper column called "Parent Checked?"

    2.) Created a column formula like this:

    =IF(COUNT(PARENT([Checkbox Column]@row)) > 0, IF(PARENT([Checkbox Column]@row) = true, "True", ""))

    Checks to see if this is a child row.

    If it is a child row it checks to see if its parent is checked. If it is it shows the text of "True"

    3.) Then ran an automation when the "Parent Checked?" column changes to "True" - it checks the "Checkbox Column" in that row.

    4.) It just takes a few seconds for the automation to take effect and you'll need to refresh the page.


    You may also want to run the opposite - having an automation to UNCHECK the child checkbox when you uncheck the parent as well.


    Let me know if this fills your needs or you have any other questions!


    -Jon Mark

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    Hi @McAfee Electric Mgr

    I hope you're well and safe!

    Yes.

    Try something like this.

    =PARENT()
    

    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic weekend!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Jon Mark H
    Jon Mark H ✭✭✭✭✭
    Answer ✓
    Options

    Assuming you want to be able to check & uncheck that parent checkbox at will, I would do the following:


    1.)Create a helper column with a formula which tells if each row is a parent or a child, and if it's a child - is its parent's checkbox checked? (see below)

    2.)Then Run an automation which triggers when the helper column changes to "True", it checks your Checkbox column.


    EXAMPLE:

    Here's what I did:

    1.) Created a helper column called "Parent Checked?"

    2.) Created a column formula like this:

    =IF(COUNT(PARENT([Checkbox Column]@row)) > 0, IF(PARENT([Checkbox Column]@row) = true, "True", ""))

    Checks to see if this is a child row.

    If it is a child row it checks to see if its parent is checked. If it is it shows the text of "True"

    3.) Then ran an automation when the "Parent Checked?" column changes to "True" - it checks the "Checkbox Column" in that row.

    4.) It just takes a few seconds for the automation to take effect and you'll need to refresh the page.


    You may also want to run the opposite - having an automation to UNCHECK the child checkbox when you uncheck the parent as well.


    Let me know if this fills your needs or you have any other questions!


    -Jon Mark

  • McAfee Electric Mgr
    Options

    @Jon Mark H Worked like a charm! Thanks! Exactly what I need it to do!

  • Jon Mark H
    Jon Mark H ✭✭✭✭✭
    Options

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!