Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Multiple colors applied to one cell
I am pulling data from an Excel sheet listing resources. These resources (cells) are color-coded based on availability, training, etc. In a couple of instances, some resources might be available AND billable and, consequently, require 2 different colors in the cell (from the legend). In Excel, there is the ability to create a shading style (using two priimary colors) where it appears as both in the same cell. Is there any kind of function in SmartSheet that can produce the same effect? Or, for that matter, select a color that is not one of the 40 in the paint button?
Thanks so much!
Comments
-
I myself would find this very useful especially in Calendar view - I currently only have one way of colour coding, which is just the background colour.
Pam - in your instance, in Grid view, perhaps you could apply a conditional format that affects the font colour? So you could have two colours - one in the background, and one for the font. Hope this helps! -
I was thinking something similar, based on selection of the checked boxes for availability, etc. The only issue I can see right now is that sometimes the planning is for several months out, with another project following (that has different availability criteria). So, while I can apply the conditional formatting, it applies to the whole row. I thought that perhaps an IF-THEN formula might work (if Box 1 checked, format cell color; when 2 boxes checked, apply the cell color for Box 1, then apply the font color for Box 2). I'm not even sure that makes sense, but I definitely think I'm at a formula point here...
I appreciate your input!
-
Pam,
If you have the checkboxes, you could perhaps use conditional formatting on the cells only instead of the whole row. I've done this for "stripes" of columns that have related functionality.
Hope this helps.
Craig
-
I'll try that, Craig - thanks!
-
This feature would be great! Please add my vote too.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives