RYG Automation based on "overall Score" Column

Mark Dekorte

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!

Mike Wilday

You have to make the column type RAG. Right-click on the column header and change it to Symbol > RYG or Red Amber Green. 

Mark Dekorte

Thanks Mike,

 

The column type is symbol with RYG selected.

Mike Wilday

From the screenshot you shared, it looks like the ball is being put in there. I guess I don't understand your question.

Can you also share the formula you are using?