Automating, If all children are checked, then check the parent row box.

Tamara

I've been struggling to write a formula. I'm trying to automate a sheet for completed projects. What I'd like to do is if all child rows are checked completed, then check the parent row. Otherwise, the parent rows are showing up on my reports and the children are long gone. Any help is appreciated! Thank You!

Paul Newcome

@Tamara Yes. You would only put this in the parent rows.

Paul Newcome

Try this:

=IF(COUNTIFS(CHILDREN(), 1) = COUNT(CHILDREN([Task Name]@row)), 1)

Just change [Task name] to reference any column in the sheet that has data in every row.

Tamara

So, this checks all the boxes in the column. I only want it to check the parent row when all the children are checked.

Andrée Starå

Hi @Tamara

I hope you're well and safe!

You'd only add it to the Parent row.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

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!

Paul Newcome

@Tamara Yes. You would only put this in the parent rows.

Tamara

Thank You Paul and Andree! This worked.

Andrée Starå

@Tamara

Excellent!

Happy to help!

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

Happy to help. 👍️

Jenni Crutcher

This formula works great! Thank you for sharing! Does anyone know if there is a way to have this formula auto populate whenever you create a new parent row?

Paul Newcome

@Jenni Crutcher To have it applied as a column formula while still keeping the child boxes manually selectable, you would need to use a second checkbox column. Then in this second column you would use something along the lines of (column formula):

=IF(COUNT(CHILDREN([Task Name]@row))> 0, IF(COUNTIFS(CHILDREN([Original Checkbox]@row), 1) = COUNT(CHILDREN([Task Name]@row)), 1))

Then you can hide this column to help keep the sheet looking clean and set up a Change Cell automation to check the box in your original checkbox column when this helper column becomes checked.