Need help with Parent Status

I would like my parent status to be RED when ALL children balls are red, yellow when at least one is yellow, otherwise green. I found this formula below in a thread, but I can't seem to get Parent to RED when ALL are red. Can someone tell me what is missing? Thanks!

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

Find more posts tagged with

Formulas

Comments

Mike Andreas

Try this:

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