Why this idea? This week we added a new value to a Status column in a grid sheet that feeds several reports that feed over 40 pie chart widgets across our dashboards. The widget colors were completely changed on every pie chart on all related dashboards, including the one viewed by our C-suite executives! This caused a great deal of maddening manual rework to reset the colors for each value before a major leadership meeting occurred. A huge reason we chose Smartsheet was Dashboards, but this widget color reset is not smart at all. See the example below.
Please redesign this immediately so that the colors we choose for our dashboard widgets do not change automatically when we add another value.
Example: We set Blocked to orange which changed to red (a color we've never chosen for any value); we had Not Started set to light gray but it changed to the green we had selected for Submitted for Approval which changed to yellow (another color we don't use). The colors below had to be reset for every pie.
