Sign in to submit new ideas and vote
Get Started

Retain dashboard widget colors after selecting new data

Chart widgets once you make a new selection of ranges for the data on a ‘Chart’ widget, it will return to the original system color. The result may be sloppy, with two data series having the same color! Consider changing the behavior so that it doesn't default to the original scheme. Instead, it should retain the color selections I've made in the past and if needed, assign a new color to new data.

Tags:
8
8 votes

Available Now!·Last Updated

Good news! Your dashboard chart colors will now persist based on the color mapping you set when a chart is created or modified. Please note that colors need to be reselected and saved for the persistence to take effect for existing charts.

Comments

  • Sarah123
    Sarah123 ✭✭✭
    edited 02/23/23

    我have a few templates that include dashboards with charts and I'd like to have specific status' have specific colors. Right now I have to enter in fake data to have the colors stick but this causes confusion when people use the templates and don't update the statuses from the fake data. It would be VERY useful to be able to set default colors for a template or even a workspace (even one that would look at if the data matches this text then this color should be used).

  • Sarah123
    Sarah123 ✭✭✭

    @Genevieve P.How can I save the colors for items that are not set in the series? Can I somehow enter in an item so that if/when it appears it will be a specific color? For example tasks by status; if it's not started have this color and in progress have this color, etc. I don't see an option to do that in the template we have. Thanks.

  • Genevieve P.
    Genevieve P. Employee Admin
    edited 04/06/23

    Hi@Sarah123

    Can you clarify what chart type you're using?

    Screenshot 2023-04-06 at 15.09.09.png


    我f you're using a Pie Chart and the values are 0 they won't show up to assign a colour.




    Screenshot 2023-04-06 at 15.07.25.png


    However you could switch the chart type to be something else (e.g. a Bar Chart) and assign a colour.

    Then change it back to a Pie Chart and Save the Dashboard.




    This should then bring up the correct colour for future data!

    Screenshot 2023-04-06 at 15.07.47.png


    Screenshot 2023-04-06 at 15.07.57.png





    Let me know if that makes sense and works for you.

    Cheers,

    Genevieve

  • Sarah123
    Sarah123 ✭✭✭

    谢谢吉纳维芙!我们using a donut chart and don't have the data entered until a status is changed for a task. Unfortunately, I tested this by doing the workaround in the project template and it didn't keep the colors I had setup when a new project was created using control center. It still selected colors on it's own. Is it possible to reopen this issue so that we can setup templates for specific colors for items? Thank you.

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi@Sarah123

    The initial release was rolled back to fix a few elements before making it live again - the status on this thread has been updated to "Coming Soon" and when this is fixed it will be changed to "Available Now".

  • Genevieve P.
    Genevieve P. Employee Admin

    Hey@Sarah123,

    This release is now available again! Please test it out and let us know if you have any further feedback.

    Cheers,

    Genevieve

  • Josh Reed
    Josh Reed ✭✭✭✭✭

    Nice I'll be looking into this. I have various dashboards with tons of metric calculations... often many datapoints temporarily fall to 0 on my pie/donuts and then come back as whatever color it wants. I wonder if this fix would work... just set everything up as a bar chart first and save, then convert to pie.

2023-05-28T08:51:38.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":106988,"type":"idea","name":"Clear Suggestions - Ability to turn this feature off.","excerpt":"In resource management, It would be great to have the ability to turn the suggested hrs off. Ideally at a project level. For some teams it may be useful, however for others its a burden as the allocations are mostly incorrect. If someone is across more than one project, e.g. working on \"client A\" Mon + Tue (40%) and…","snippet":"In resource management, It would be great to have the ability to turn the suggested hrs off. Ideally at a project level. For some teams it may be useful, however for others its a…","categoryID":349,"dateInserted":"2023-06-28T00:30:37+00:00","dateUpdated":"2023-06-28T00:30:52+00:00","dateLastComment":"2023-06-28T00:30:37+00:00","insertUserID":162520,"insertUser":{"userID":162520,"name":"gvattura","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/gvattura","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-28T00:30:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":162520,"lastUserID":162520,"lastUser":{"userID":162520,"name":"gvattura","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/gvattura","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-28T00:30:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":12,"score":1,"hot":3375824789,"url":"https:\/\/community.smartsheet.com\/discussion\/106988\/clear-suggestions-ability-to-turn-this-feature-off","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106988\/clear-suggestions-ability-to-turn-this-feature-off","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106988,"name":"Clear Suggestions - Ability to turn this feature off.","url":"https:\/\/community.smartsheet.com\/discussion\/106988\/clear-suggestions-ability-to-turn-this-feature-off","dateInserted":"2023-06-28T00:30:37+00:00","insertUserID":162520,"insertUser":{"userID":162520,"name":"gvattura","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/gvattura","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-28T00:30:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106969,"type":"idea","name":"Conditional Formatting for Dashboard Metric Widgets","excerpt":"When using dashboard metric widgets, it would be helpful to be able to have conditional formatting features to compare performance to a KPI or otherwise enhance the metric display. Even if the data source document already has the conditional formatting existing, it will not transfer along with the data to the dashboard…","snippet":"When using dashboard metric widgets, it would be helpful to be able to have conditional formatting features to compare performance to a KPI or otherwise enhance the metric…","categoryID":349,"dateInserted":"2023-06-27T18:40:37+00:00","dateUpdated":"2023-06-27T19:26:00+00:00","dateLastComment":"2023-06-27T18:40:37+00:00","insertUserID":160171,"insertUser":{"userID":160171,"name":"GMichal","url":"https:\/\/community.smartsheet.com\/profile\/GMichal","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T19:24:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":160171,"lastUserID":160171,"lastUser":{"userID":160171,"name":"GMichal","url":"https:\/\/community.smartsheet.com\/profile\/GMichal","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T19:24:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":16,"score":4,"hot":3375786397,"url":"https:\/\/community.smartsheet.com\/discussion\/106969\/conditional-formatting-for-dashboard-metric-widgets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106969\/conditional-formatting-for-dashboard-metric-widgets","format":"Rich","tagIDs":[292,363,437],"lastPost":{"discussionID":106969,"name":"Conditional Formatting for Dashboard Metric Widgets","url":"https:\/\/community.smartsheet.com\/discussion\/106969\/conditional-formatting-for-dashboard-metric-widgets","dateInserted":"2023-06-27T18:40:37+00:00","insertUserID":160171,"insertUser":{"userID":160171,"name":"GMichal","url":"https:\/\/community.smartsheet.com\/profile\/GMichal","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T19:24:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":4}],"tags":[{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}]},{"discussionID":106931,"type":"idea","name":"Pinning on the home page","excerpt":"📌would be great to PIN certain sheets and dashboards to my home page.","snippet":"📌would be great to PIN certain sheets and dashboards to my home page.","categoryID":349,"dateInserted":"2023-06-26T23:04:11+00:00","dateUpdated":null,"dateLastComment":"2023-06-27T22:36:33+00:00","insertUserID":81486,"insertUser":{"userID":81486,"name":"Trish Dillon","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Trish%20Dillon","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ejFZp_HtGHw!wf9YcMXtCfo!EieK1GzsuNz","dateLastActive":"2023-06-26T23:01:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":161565,"lastUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T22:41:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":14,"score":2,"hot":3375727244,"url":"https:\/\/community.smartsheet.com\/discussion\/106931\/pinning-on-the-home-page","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106931\/pinning-on-the-home-page","format":"Rich","tagIDs":[363,451],"lastPost":{"discussionID":106931,"commentID":382722,"name":"Re: Pinning on the home page","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382722#Comment_382722","dateInserted":"2023-06-27T22:36:33+00:00","insertUserID":161565,"insertUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T22:41:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":451,"urlcode":"home-and-navigation","name":"Home and Navigation"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&dateInserted=%3E2023-05-28T08%3A51%3A38%2B00%3A00&type%5B0%5D=Idea&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":147,"limit":3},"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">