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.
Answers
-
I don't believe you can. I wish though. Maybe you can submit it as an idea for them to consider.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives