I have a to do list with parent tasks and children tasks. I have a status column with a dropdown menu with the options “Not started,” “In process,” and “Completed.” I want to have a formula that auto-populates the parent task with the status based on the children tasks. Here is the logic that I want the formula to use: * If all children tasks are not started, parent task is not started * If all children tasks are completed, parent task is completed * If some children tasks are not started, some are completed and some are in process, parent task is in process * If some children tasks are not started and some are completed, parent task is in process * If some children tasks are in process and some are not started, parent task is in process * If some children tasks are in process and some are completed, parent task is in process I am currently using the following formula and it is working for every task except when I have a mix of children tasks that are completed and not started, it is listing the parent task as not started. =IF(COUNTIF(CHILDREN(), "Completed") = COUNT(CHILDREN()), "Completed", IF(COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started", IF(COUNTIF(CHILDREN(), "In Process") > 0, "In Process", "Not Started")))

Logic for parent row status

I have a to do list with parent tasks and children tasks. I have a status column with a dropdown menu with the options “Not started,” “In process,” and “Completed.” I want to have a formula that auto-populates the parent task with the status based on the children tasks. Here is the logic that I want the formula to use:

If all children tasks are not started, parent task is not started
If all children tasks are completed, parent task is completed
If some children tasks are not started, some are completed and some are in process, parent task is in process
If some children tasks are not started and some are completed, parent task is in process
If some children tasks are in process and some are not started, parent task is in process
If some children tasks are in process and some are completed, parent task is in process

I am currently using the following formula and it is working for every task except when I have a mix of children tasks that are completed and not started, it is listing the parent task as not started.

=IF(COUNTIF(CHILDREN(), "Completed") = COUNT(CHILDREN()), "Completed", IF(COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started", IF(COUNTIF(CHILDREN(), "In Process") > 0, "In Process", "Not Started")))

Find more posts tagged with

Formulas

Automations

Accepted answers

All comments

Nitish K

Hi @Jennifer24171659

I have tried this formula and got the result. See if it suits your need also to the above question

IF(COUNTIF(CHILDREN([Status]@row ), "Not Started") = COUNT(CHILDREN([Status]@row )), "Not Started", IF(COUNTIF(CHILDREN([Status]@row ), "Completed") = COUNT(CHILDREN([Status]@row )), "Completed", "In Process"))

I have attached a screenshot also for reference

Jennifer24171659

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.