Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Need help with Parent Status

edited 12/09/19 in Archived 2017 Posts

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



This discussion has been closed.