When adding statuses in a drop-down menu, having the option to assign a color so that when you create pie charts all the status legends are the same. Or having some feature to make sure your legends were consistent.
Sign in to see the current vote count, add your own vote, or leave a comment.
@hbaksys I agree this would be very helpful and save a lot of time! I have the same standardized colors for status and having to update them each time is a detail I'd like to not have to think about.
In our dashboards we use the same tracker (in the same Workspace) to generate various reports/widgets for different levels of status updates.
For example, 1 widget may report # of each type of status (4 New, 6 In Progress, 2 Ready for Review, 10 Closed - etc). Another widget needs to report % of each status (18% New, 27% In Progress, 10% Ready for Review, 45% Closed - etc).
Even though the dashboard and trackers are created from templates AND both widgets pull from the same tracker, the issue is both widgets do not default to the same color legend for "New", In Progress", "Closed" etc. "New" in the # widget may default to blue but "New" in the % widget may default to green once the templates are used to create a new workspace.
It would be very time saving if there was a a way to "lock" a specific color in a dashboard legend to a specific dropdown response when multiple widgets are pulling from the same column from the source document. Currently this is a manual process of aligning all widgets to the same colors for each status option.
Please consider adding this feature! At present, it's difficult to maintain color consistency for categories across multiple pie charts and dashboards (e.g. Marketing is Red, Purchasing is Green) which gets hairy if there's 6+ categories to recolor.
So glad I found this post! I thought I was missing where I correct these consistency issues. Just to clarify everyone using Dashboards is manually updating these colors every time they put new data into the source sheets?
Although we are extremely proficient when it comes to reducing load on our smartsheets (we use pivot, data mesh and data shuttle extensively), we still find ourselves hitting capacity limits (mostly because of the number of columns in conjunction with some pretty complex formulas). Breaking up data between sheets and…
Problem Smartsheet environments quickly become cluttered with inactive Sheets, Reports, and Dashboards that are no longer viewed or updated. This creates confusion for users and significant overhead for admins, especially in large or regulated environments. There is currently no native way to automatically identify, notify…
Hi Smartsheet Team and Community, I would like to raise an urgent enhancement request regarding Data Mesh source sheet configuration. This limitation is causing significant operational issues for teams relying on automated updates through APIs and database integrations. 📌 The Problem When the source sheet connected to a…
