Colors for chart widget not preserving settings

Options
JeffM
JeffM
edited 12/09/19 in Smartsheet Basics

Hi all!

I am fairly new to Smartsheet but have been taking training where I can to get up to speed. I'm stuck on one particular issue and I'm hoping someone can help.

I set up a couple of donut chart widgets to track task status for a couple of sub-projects. These charts get data from a metrics sheet I set up. The idea is to simply show the % of project tasks that are in these four categories and use the colors that I've indicated.

Complete (blue)

On Track (green)

At Risk (yellow)

Off Track (red)

If you look at the attached screenshot you'll see my issue. In the top chart, there are no project tasks currently in "Off Track" status, so the metrics sheet has it at 0%. The chart widget then decides on its own, somehow, to change the color of "On Track" from green to red. This is obviously very misleading as red is for bad, not good things. :)

Is there any way around this issue that I'm missing? Thank you!

Chart Screenshot.jpg

Comments