Need help with Parent Status

SharonJ

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"))

Mike Andreas

Try this:

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