Check Boxes with Parent / Child Rows

McAfee Electric Mgr

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?

Jon Mark H

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

Andrée Starå

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!

Jon Mark H

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

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

Jon Mark H

@McAfee Electric Mgr Glad I could help!