Parent Row Formula Based on Children's Status

stephanie.blake67241

How do I use a formula in my parent row to update based on the children's status? I want the parent row to to "Active" if any of the children are "Active", "Complete" if all of the children are "Complete, otherwise, "Inactive. 

SYSPK

I would use an IF formula. Try this:

=IF(countif(children(),"Active")>0,"Active",IF(countif(children(),"Complete")=count(children()),"Complete","Inactive"))

stephanie.blake67241

How could I adjust this formula to say in addition to what's noted, if any of the children are "Canceled" the parent should also be "Canceled"?