-
Change date color beyond certain time period
Hello! This seems like it should be easy but I'm having trouble figuring it out. I would like to have the cells in a date column turn different colors after a number of days has passed. For example, if the date is over 30 days, I would like the conditional formatting to change to yellow. If it is over 60 days, I would like…
-
Change Background Color of Dropdown Bubbles
Is there a way to change the background color of the dropdown bubbles? On the main report, everything is in its own gray dropdown bubble, which is best for black text. However, when I run a report, the dropdown bubble is removed, leaving the text over a background color that varies with our color coding. In this case,…
-
Rename labels when using custom colours
I am using Symbols in my sheet for 'risk level' using the standard Red, Yellow & Green. I then have a report showing how many/what percentage of risk we have per risk status above. I have added the report as a widget into a dashboard and am using my companies branded colours in a donut chart, however the label of each…
-
IDEA for Copy Row Automation: Also Copy Assigned Dropdown Value Colors
If Colors in a dropdown column are setup (In Table View), the Copy Row automation should retain those same colors when copied to the new sheet. Just like how cell colors copy over, I'd like those assigned colors to copy as well.
-
Smartsheet Color Matrix Names and Hex Codes + Programmatic Conditional Formatting
Howdy Smartsheet Community :) During a recent exercise to make Conditional Formatting programmatic, I indexed the color names and hex codes of the 8 x 5 Smartsheet color matrix. Wanted to share the results with everyone here, in case you have a need to extend these colors through non-Smartsheet collateral: Some details on…
-
Merged: Color consistency in dashboard legends when pushing status report info across multiple widg…
This discussion has been merged.
-
Template Formatting For Graphs - Consistent Colors
Is there a way to keep the colors consistent for graphs. For example, I created a graph showing units by color, with columns. Right next to it, I created a pie chart using the same source data but the colors for each unit represented are different. I know I can change them to match, but what a pain to do this for all my…
-
Dashboard Charts - Color Change Issues
Hello, I have had issues with my dashboard charts changing colors when values drop to 0 and then come back above 0. It changes everything and I have to manually fix this issue. I found a solution on the Smartsheet community site that recommended adding +0.0001 to the end of the value. This solved my problem but created…
-
FORMULA COLORS: Color Correct Part of Formula and Gray from error part forward. Don't Grey it all.
I LOVE that when you are writing a formula in Smartsheet, the formula adds colors to the references as you make successful references to cells. And how it goes "Grey" if there's a problem in the formula: However, It would be VERY VERY VERY VERY VERY helpful if you could keep the PROPERLY referenced cells in color, and ONLY…
-
Change header color in email notifications
I'd like to change the header color in my email notifications so that my logo is readable. It appears this is controlled by “Workspace Colors & Logo,” but I’m locked out of those settings unless I upgrade to a Business account. I have a Pro account now. Upgrading to a business account doubles my monthly subscription fee,…