Health Status on Report

Shane Burdon

Hi All,

I've been building my files and reports. I've gotten my RGY formulas down, however, how in the world do I get it to give me a RGY health summary as it does for the other columns? I have a report that pulls in each rep as I have it below, just missing that one piece!

Am I missing a step?

Jeff Reisman

@Shane Burdon A report won't be able to give you that summary for RYG values, because there's no way for it to find an average value between the words "Red," "Yellow," and "Green."

You could do this on a metrics sheet where you pull values from the monthly sheets, and assign a numeric value to each color in a helper column, and then find the average of those values and use an IF statement to determine the ball color to use for that average value.

(There are a slew of Smartsheet Community threads on how to do the above: https://www.google.com/search?q=smartsheet+average+of+RYG+values&rlz=1C1GCEB_enUS833US833&oq=smartsheet+average+of+RYG+values&aqs=chrome..69i57j0i546l4.9632j0j7&sourceid=chrome&ie=UTF-8 )