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

Pam Tadsen
Pam Tadsen ✭✭✭✭✭
edited 12/09/19 in Archived 2016 Posts

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!



  • JLC
    JLC ✭✭✭✭✭✭

    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!

  • Pam Tadsen
    Pam Tadsen ✭✭✭✭✭
    edited 02/11/16

    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!

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭



    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.



  • Pam Tadsen
    Pam Tadsen ✭✭✭✭✭

    I'll try that, Craig - thanks!

  • dbrody

    This feature would be great! Please add my vote too.

This discussion has been closed.