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!
Tags:
Comments
-
You have to make the column type RAG. Right-click on the column header and change it to Symbol > RYG or Red Amber Green.
-
Thanks Mike,
The column type is symbol with RYG selected.
-
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?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!