Donut Chart - How to automatically color red, yellow, green?

Hello, I've created a donut chart that shows a score as a fraction of a total score. I'd like to have it automatically color the score portion red, yellow or green based on a range of the score to the total. Excel does this using donut charts and formulas. How can I do this in Smartsheet? I was able to color it appropriately manually by choosing the color, but it would be fantastic for that to be automated. Thank you.


Answers