Parent Row Formula Based on Children's Status

stephanie.blake67241 · 02/11/19

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 · 02/11/19

I would use an IF formula. Try this:

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

stephanie.blake67241 · 10/30/19

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"?

Parent Row Formula Based on Children's Status

Comments

Categories