Auto showing completion based on child checkboxes

C F

Hello.  I've setup a task list with check boxes.  After indenting portions of it to show child tasks, is there a way to have the parent row automatically highlight, or show a value, when all the child tasks are complete?

I would then link the parent row back to a master sheet to show a completion on a single line in the master sheet.

Thank you for your advice.  I have a sample photo attached.

 

Robert Casper

This formula will automatically fill in the "Done" checkbox for the parent row

=IF(COUNT(CHILDREN()) = COUNTIF(CHILDREN(), true), true, false)

 

Robert