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.
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.
我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).
@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.
谢谢吉纳维芙!我们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.
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".
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":[]}">