RYG Formula for Parent and Children Rows
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")))
Best Answer

Try something like this...
=IF(COUNTIFS(CHILDREN(), "Red") >= 3, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") >= 3, "Yellow", IF(COUNTIFS(CHILDREN(), "Blue") = COUNT(CHILDREN()), "Blue", "Green")))
Answers

Try something like this...
=IF(COUNTIFS(CHILDREN(), "Red") >= 3, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") >= 3, "Yellow", IF(COUNTIFS(CHILDREN(), "Blue") = COUNT(CHILDREN()), "Blue", "Green")))

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

Yes. Those signs must be in a specific order for them to work.
"<=" will work, but "=<" will not.

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/gettogripswithnestedfunctions/

@Gwen Rymill SBP Thank you! I will check that out!
Help Article Resources
Categories
Check out the Formula Handbook template!