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?
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…
The current logic behind the "Last Activity" column in the True-Up is not useful for performing True-Up nor ongoing reviews of licensed seats. I need to know when someone last made a modification to any sheet regardless of the level assigned to the modified sheet. In my case I have a project manager who is an owner on…
Today you can create a form and add logic. If that logic requires that requests need to be made for X days in the future you can add logic to help. For instance is the date requirement is not met you can hide fields so that information cannot be submitted completely. You can display a banner if date requirements are not…
