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