Health Formula - RGY

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.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!