RGY Status - Overall Roll up

Hello helpful Smartsheet-ers!

I have several rows that are utilizing the RGY buttons for health. I am trying to roll these up to a general status based on the choices in the individual rows. Can anyone help with a single formula that would capture:

Green if all elements (rows) are green

Yellow if one or more elements are yellow

Red if one or more elements are red.

So at the end of the day, I have 10 rows, 2 of those rows are red, I want the general status to show red; or all 10 rows are green, I want the general status to show red, and so on... 

Does that make sense?

 

Thanks so much, Lindsey

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!