Health Formula - RGY

Ryan Levitz

Looking for an assist with a formula. I want the parent health bubble to show the 'worst' status of any of its children. Basically: if a child's health is red, the parent's is red; if a child's health is yellow, the parent's is yellow, otherwise the parent's is green.

Thanks!

Paul Newcome

Try something like this...

=IF(CONTAINS("Red", CHILDREN()), "Red", IF(CONTAINS("Yellow", CHILDREN()), "Yellow", "Green"))

Paul Newcome

Try something like this...

=IF(CONTAINS("Red", CHILDREN()), "Red", IF(CONTAINS("Yellow", CHILDREN()), "Yellow", "Green"))

Ryan Levitz

Thanks Paul. That got me where I needed to go. Appreciate it!

Paul Newcome

Happy to help. 👍️