Populate Status Based on Children

KCharron52

I need a formula that will auto populate the status of a parent task based on its children's statuses. If all children have the status "Not Started", the parent should reflect "Not Started". If any children have the status "In Progress", the parent should reflect "In Progress". If all children have the status "Complete", the parent should reflect 'Complete".

The sheet will grow and change over time so I need to use the CHILDREN() function instead of ranges.

Matt Lynn-PCG

@KCharron52

=IF(COUNT(CHILDREN()) = COUNTIF(CHILDREN(), "Complete"), "Complete", IF(COUNT(CHILDREN()) = COUNTIF(CHILDREN(), "Not Started"), "Not Started", "In Progress"))

Matt Lynn-PCG

@KCharron52

=IF(COUNT(CHILDREN()) = COUNTIF(CHILDREN(), "Complete"), "Complete", IF(COUNT(CHILDREN()) = COUNTIF(CHILDREN(), "Not Started"), "Not Started", "In Progress"))