Automatic checkbox in parent row when children are all checked?

Amy Rodriguez · 10/20/15

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

Brett Evans · 10/20/15

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 · 10/20/15

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 · 10/20/15

What ^he^ said.

Jeff Smith · 01/26/16

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 · 01/27/16

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