Parent/Child row formula

NV Smith

I have a project plan where the status can be any of the following drop downs - Complete, On Track, At Risk, Behind Schedule, Not Started, Discontinued. I need help with a formula that will adjust the parent status based on the children. If all children are complete = "Complete". If all children are On Track or Not Started = On Track. If more than one child is At Risk = At Risk. If more than one child is Behind Schedule = Behind Schedule. Discontinued should not impact the parent status at all. I have tried several formulas and I keep receiving the #unparsed error, so any help would be greatly appreciated.

Michelle Choate 2

Hello @NV Smith !! This one was fun!!

=IF(COUNTIFS(CHILDREN(), OR(@cell = "Complete", @cell = "Discontinued")) = COUNT(CHILDREN()), "Complete", IF(COUNTIFS(CHILDREN(), OR(@cell = "Discontinued", @cell = "On Track, @cell = "Not Started")) = COUNT(CHILDREN()), "On Track", IF(COUNTIF(CHILDREN(), "At Risk") > 1, "At Risk", IF(COUNTIF(CHILDREN(), "Behind Schedule ") > 1, "Behind Schedule "))))