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?
Most customer's metadata houses their profile data, some from intake sheet and some either cell linked in or brought into metadata using formulas. Needs change after design and often the new data point needed comes from non-metadata templates, which can cause a blocker if methods used are those above. If it were possible…
Having the ability to auto-resize the Calendar App view based on the widget size is needed. We have a "Due in 7 Days' calendar for our dashboards and would like it to be anchored at the top right. Unfortunately, as currently designed, the calendar takes up a significant amount of space and must be moved to the bottom.
Our sheets & workspaces require many people to have Admin level capabilities, which means that when someone requests access to a sheet or workspace, that email is sent to every Admin. This causes confusion and higher risk of no access granted (because people have learned to ignore the emails) or the wrong level of access…
