RYG Formula for Parent and Children Rows

Maria Watters

Hello,

I am trying to create a formula where the parent health turns Red if there is more than 3 red children health's, Yellow if there are more than 3 yellows, Blue if everything below it is Blue and the rest of the time green.

Is this possible?

I was using this formula for a while, but realized major gaps and it wasn't actually doing what we needed it to be doing.

=IF(COUNTIFS(CHILDREN(), "Red") > 1, "Red", IF(COUNTIFS(CHILDREN(), "Red") , > 1 "Yellow", IF(COUNTIFS(CHILDREN(), "Yellow") > 1, "Yellow", "Green"))) 

Paul Newcome

Try something like this...

=IF(COUNTIFS(CHILDREN(), "Red") >= 3, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") >= 3, "Yellow", IF(COUNTIFS(CHILDREN(), "Blue") = COUNT(CHILDREN()), "Blue", "Green")))

Paul Newcome

Try something like this...

=IF(COUNTIFS(CHILDREN(), "Red") >= 3, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") >= 3, "Yellow", IF(COUNTIFS(CHILDREN(), "Blue") = COUNT(CHILDREN()), "Blue", "Green")))

Maria Watters

Yes! thank you. I tried the = sign, but i had it before the greater/less than signs.

Paul Newcome

Yes. Those signs must be in a specific order for them to work.

"<=" will work, but "=<" will not.

Gwen Rymill SBP

Hi Maria,

You might be interested in the formula we created for using Column Formulas in sheets that use Row Hierarchy https://www.smarterbusinessprocesses.com/get-to-grips-with-nested-functions/

Maria Watters

@Gwen Rymill SBP Thank you! I will check that out!