Dashboard Custom Colors
I created custom colors for a dashboard. I'm now creating a style sheet to document the dashboard's colors, fonts, etc. How do I find the RGB color mixture for the custom color I created?
Answers
-
Colleen Patterson ✭✭✭✭✭✭
@ShannonTozierThe dashboards provide the Hex code of the color, and the easiest way to find that is clicking on the dashboard element that you colorized, opening the edit widget and then going to the color section. In the graphic below, I have the Chart Widget open, and the series selected with the color listed. If I NEED the RGB value, I google the hex code number followed by in RGB example for the below is 577bbd in RGB, and then good returns the values.
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
-
Thank you@Colleen Pattersonfor responding so quickly.
Unfortunately, the custom color isn't in a chart, but rather a background widget color. Do you know how to look up that color?
-
Colleen Patterson ✭✭✭✭✭✭
If this was me, since that view will not open the custom color view panel, I would (for the sake of extraction) create a fake chart, to pull the color codes out. The custom colors are unique to a dashboard, but usable for other widgets on the same dashboard, so it will let you use them to configure a different visual. Once done, you can remove the sample chart widget. Below is the help text found on the Smartsheet help article regarding custom dashboard colors:
Apply custom colors
When selecting colors for fonts, charts, titles, and more, you can choose from standard presets or add a custom color using a HEX code, an RGB code, or a color gradient.
To create your own custom color
- Go to the color palette of a widget.
- In the Custom Colors section, select the Add Color icon.
- Pick a color or enter the hexadecimal color value, and then select Add.
What you should know about custom colors
- Up to 20 custom colors will be saved on a dashboard.
- Custom colors are unique to the dashboard you are editing, and won't be visible on other dashboards. If you add a custom color to widget A, you’ll be able to quickly select the same custom color on widget B if these widgets are on the same dashboard.
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
-
Thanks,@Colleen Patterson
Categories
Hi @Jagdeep<\/a> - Unfortunately, my experience has been that Datamesh \"Immediate\" can take up to 5 minutes (perhaps more).<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":381,"urlcode":"DataMesh","name":"DataMesh"}]},{"discussionID":106941,"type":"question","name":"How to show data of previous working day?","excerpt":"For a stacked column chart on a dashboard, I count the number of applicable cases daily. The current formula shows NO DATA on Monday because TODAY(-1) is Sunday. =COUNTIFS({Customer Escalation Region}, $Region@row, {Customer Escalation Request Reason}, \"Close Gap\", {Customer Escalation Request Date}, TODAY(-1)) I'm…","snippet":"For a stacked column chart on a dashboard, I count the number of applicable cases daily. The current formula shows NO DATA on Monday because TODAY(-1) is Sunday.…","categoryID":321,"dateInserted":"2023-06-27T10:29:20+00:00","dateUpdated":null,"dateLastComment":"2023-06-27T12:02:55+00:00","insertUserID":162184,"insertUser":{"userID":162184,"name":"Sachiko Kagami","title":"Customer Service Manager","url":"https:\/\/community.smartsheet.com\/profile\/Sachiko%20Kagami","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T12:25:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":151203,"lastUser":{"userID":151203,"name":"Nick Korna","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Korna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T12:11:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":23,"score":null,"hot":3375730935,"url":"https:\/\/community.smartsheet.com\/discussion\/106941\/how-to-show-data-of-previous-working-day","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106941\/how-to-show-data-of-previous-working-day","format":"Rich","lastPost":{"discussionID":106941,"commentID":382502,"name":"Re: How to show data of previous working day?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382502#Comment_382502","dateInserted":"2023-06-27T12:02:55+00:00","insertUserID":151203,"insertUser":{"userID":151203,"name":"Nick Korna","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Korna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T12:11:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-27T11:47:48+00:00","dateAnswered":"2023-06-27T11:40:22+00:00","acceptedAnswers":[{"commentID":382497,"body":" Hi @Sachiko Kagami<\/a>,<\/p> The WORKDAY function is what you're after here.<\/p>
