Parent Status Condition Logic Dependent on Children

akelly

Hi!  I am looking to have my parent header updated to complete once all children are complete or display in progress if any of the children are still in progress.  If all children are Not started I want the status of the parent header to be not started.  I am sure this is simple....but I stuck.

 

Thanks!

Paul Newcome

Try something along the lines of this...

 

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

Paul Newcome

Try something along the lines of this...

 

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

akelly

Thanks Paul! Was able to use this and it helped! Getting used to Smartsheets. Sorry for the late response.