Column formula for checking off a parent task when its children are checked

malden

I am looking for a formula to check "Done" when a task's children are all checked "Done."

Importantly, I would like this to be a column formula.

What would be the syntax to ask a formula to exclude tasks that have no children themselves?

Here's the formula we have been using, which only works when limited to parent rows, not when applied to the whole column:

=IF(COUNTIFS(CHILDREN(), 1) = COUNTIFS(CHILDREN(), OR(@cell = 1, @cell <> 1)), 1)

Ray Lindstrom

@malden,

A column formula will prevent you from being able to use the checkbox for the child rows. You won't be able to click to check the box. You can only use a column formula in a checkbox column when you plan on automating the checkbox for every row based off criteria from some other columns.

Ray Lindstrom

@malden,

A column formula will prevent you from being able to use the checkbox for the child rows. You won't be able to click to check the box. You can only use a column formula in a checkbox column when you plan on automating the checkbox for every row based off criteria from some other columns.

malden

@Ray Lindstrom I see... Thanks for the information, that makes sense!