Welcome!

Home
Forum Archives
Archived 2017 Posts

Changing Parent to red, yellow, green based on child

Hi,

I'm trying to create a status report that will change the parent status to "Red" if one of the children are in "red", or yellow if the child milestone is in Yellow. These are milestones, so there should rarely be a red milestone and a yellow milestone at the same time, unless we're really off track. Can anyone help?

Thank you

Find more posts tagged with

Comments

Brett Evans

Patricia,

Putting this formula in your paren row RYG column will get youi there.

=IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", "Green"))

I hope this helps.

-Brett