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

Kathy T.

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.

Michael Culley

I don't believe you can. I wish though. Maybe you can submit it as an idea for them to consider.