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

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)

Find more posts tagged with

Formulas

Accepted answers

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.

All comments

Ray Lindstrom

@malden,

malden

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.