How can I have a parent card marked as "Done" if all their sub-tasks are complete

We are using the card view to provide use case testing for our clients. Currently, the sub-tasks roll up to a parent row which makes the card. However, when sub-tasks are marked done (using the checkbox functionality in cards), I can't figure out how to have the parent row automatically mark complete.

I used conditional formatting to have those checked as done turn green and then unchecked red. Currently, the card remains red even if all sub-tasks are checked as done.

Find more posts tagged with

Accepted answers

Paul Newcome

Enter the following into the parent row checkbox

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

Basically this counts how many are checked and compares to how many should be checked. If the numbers match that means they are all checked and will then check the parent row box.

All comments

Paul Newcome

Enter the following into the parent row checkbox

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

Basically this counts how many are checked and compares to how many should be checked. If the numbers match that means they are all checked and will then check the parent row box.

Daniel Hampshire

I found this question/answer when trying to mark a Parent task status "Complete" if all sub tasks were complete. I kept running into an issue with the COUNT(CHILDREN()) function on Parent tasks so going to post this in case anyone else finds their way here:

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

Paul Newcome

@Daniel Hampshire Which portion are you referring to, and which issue were you running into?

Lacy Walton

@Daniel Hampshire Thank you for the formula! Worked perfectly and solved my problem quickly.

James Raikes

Thank you this formula really helped

Nikki. A

The formula here marks everything as Completed on my smartsheet:

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

What I want is for the parent to be marked completed if all its children are completed and if not, I want the children to keep the status they have

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.