RYG Automation based on "overall Score" Column

We do a customer follow up for every job we do. We ask 3 questions rated 1-10. 

If "Overall Score" column totals  26-30 points - green ball

20-25 points - yellow ball

>20 points red ball.

I can get the column to automatically put the word of the colour in, but not the actual ball. 

 

Is there a formula for such a thing?

Thanks in advance!

Capture.PNG

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!