-
Color-Coded Tags in Board View
I noticed in the Board View tags are grey by default but in the how to videos, in the Board View some of the tags are colorful. I'd like to leverage that same functionality as I'm building a research repository with many different types of research in it and a visual cue would be lovely. Can anyone assist? I attached a…
-
How do I add colors to a custom chart series theme within the dashboard?
I was working on creating a custom theme, and when I did that it populated with several colors for chart series colors. I began removing them because they weren't the colors I wanted and I saw a "+" button to add colors I did want. Now it won't do anything when I try to click the plus sign to add a new color. I'm stuck…
-
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…
-
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.
-
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…
-
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,…
-
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,…
-
Card view: can I make color changes persist?
Is there a way I can make manual color changes persist? I cannot find a conditional formatting rule that overrides manual color changes, so it's a mystery to me why my team's changes disappear. Thanks for any advice or guidance!
-
Workspace tags or formatting
I would like to be able to sort or tag or otherwise format my workspaces in the browse view. I've got several different projects going on and it would be helpful to my brain to visually sort them. Something like this: Or perhaps create higher level Workspaces to better sort projects? Just an idea. Thanks for considering.
-
Text readability on Status Bar depending on shade selected in Timeline View
In Timeline view, when the darkest color of any of the shades is selected to color the task bar (except Yellow), the text is truncated. I only tested the darkest shades, not all of them. Please fix this bug.
-
Workspace color & logo needs to be more prominent
I use workspaces with clients and brand the workspace with the clients logo and brand colors. This used to show across the top of every page within the workspace, but a recent update has removed this so that it only appears when you have the "workspace panel" open. The result of this is that 1) the logo looks odd in many…
-
Overall Project Health Formula
Hiya folks, We want one field to show Overall Project Health. Ideally, we would figure out how to average the colors and/or tasks past due to return RYBG for the overall projects (about ~230) so that we can report it on a Dashboard. Any ideas on formula would be so appreciated. Circular reference error formula in OPH row:…
-
Timeline View: conditional formatting turns everything gray?
When using the Group feature in Timeline View, I appreciate how each group is given its own color. However, I would like to use conditional formatting to color bars a different color when a condition is met. However, when testing this, every time I use any type of conditional formatting, it turns the entire timeline view…
-
Folder Colours
It would help to differentiate the folders (particularly in Workspaces) if we could choose colours of the folders.
-
How can I automate the process of giving indented lines a different color?
How can I automate the process of giving indented lines a different color? For example, the top level should be gray, the second light gray, etc. This discussion has been moved into an English category.
-
Dropdown Menu fonts conflicting with cell background
Hello! When a drop down value is used where light font is chosen, it renders the font within the drop down option unreadable because smartsheet applies a light background color to the down values themselves. See below. Work around is to clone each conditional formatting rule to apply darker font to certain columns, but…
-
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…
-
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…