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

Options

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)

Tags:

Best Answer

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    Answer ✓
    Options

    @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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!