Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Automatic checkbox in parent row when children are all checked?

Options
edited 12/09/19

Hi,

This seems like it should be a simple thing to do, but I'm having trouble figuring it out. Is there a way to have the parent row automatically checked when all of the children rows belonging to it are checked? I'm trying to make a formula but nothing is working for me.

Thanks,

Amy

Tags:

• ✭✭✭✭✭✭
Options

Amy,

I think the only function you can use on check boxes to compare them is equals to.

https://app.smartsheet.com/b/publish?EQBCT=35cef6f3a0134843a68074a294a182ed

In production you could hide the two columns on the right.

-Brett

• ✭✭✭✭✭✭
Options

This is the formula that goes in the checkbox field. I am assuming your Primary column is named "Primary Column" and that we're working in row 1.

=IF(COUNT(CHILDREN([Primary Column]1)) = COUNTIF(CHILDREN(), 1), 1, 0)

• ✭✭✭✭✭✭
Options

What ^he^ said.

• Options

I'm missing something here. I am trying to use this to set the RYG to Red on the Parent level if all the RYG balls at the Children's level is Red else keep the Parent level Green.

This is what I have.

=IF(COUNT(CHILDREN(Availability5)) = COUNTIF(CHILDREN(), "Red"), "Red", "Green")

What am I missing?

• Employee
edited 01/27/16
Options

Jeff - I just pasted your formula into my sheet and it worked as expected. The parent RYG ball is red if all the children are red and the parent RYG ball is green if this condition is not true.

Make sure your CHILDREN() function is referencing the primary column parent cell as that is the most likely column to contain data in each child row.

• Options

Thanks Travis.

• Options

Resolved. Just put following formula in parent checkbox.

=IF(COUNTIF(CHILDREN(), 0) > 0, 0, 1)

• Options

Ratka's solution worked for me perfectly.  When all of the children checkboxes were checked, the parent became checked, as well.

This discussion has been closed.