Automatic checkbox in parent row when children are all checked?

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

Find more posts tagged with

Formulas

Comments

Brett Evans

Amy,

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

I solved your question in this link:

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

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

-Brett

John Sauber

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)

Brett Evans

What ^he^ said.

Jeff Smith

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?

Travis

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.

Screen Shot 2016-01-27 at 9.49.54 AM.png

Screen Shot 2016-01-27 at 9.50.01 AM.png

Screen Shot 2016-01-27 at 9.50.09 AM.png

Jeff Smith

Thanks Travis.

Ratka Zdenek

Resolved. Just put following formula in parent checkbox.

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

MGumenick

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