Automating Parent Row based off RYG Children Rows

LindseyC

Hello!

I am looking for a formula that will show in the parent row an RYG color based on the children.

If there are any Red OR Yellow in the children rows, I want the parent row to show Yellow.

If there are only greens (no other color), I want the parent row to show Green.

How do I do the "or" statement? Thanks for any help!

Lindsey

Find more posts tagged with

Formulas

Comments

Atus Bartal

Lindsey,

here it is (modifying Craig's solution here):

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

Atus

LindseyC

Hi Atus! Thank you so much! Once again, you are so helpful.

Is possible to add a third "OR" criteria (such as if yellow or red or blue in children, then turn parent row yellow). I would assume it is, but when I tried to add in that third criteria, it comes up as an error.

Thanks!

Atus Bartal

You're welcome. Happy to help.

Then it will look like this:

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

LindseyC

Oh I see what I did. I did the same formula, but forgot to move the paranthesis. Thanks again for helping, Atus! Very much appreciated.