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.

If cell fill is a given hex color code, then return value

SarahG
SarahG
edited 12/09/19 in Archived 2017 Posts

How can I identify the hex color code for the cell fill options?

I want to write an IF statement to return value of 1 if the hex color code is the darkest blue (as an example).  

A little background.... reporting 6 status stages so the symbols aren't an option. Thanks in advance for your help!

 

Comments

  • Chris McKay
    Chris McKay ✭✭✭✭✭✭

    Unfortunately, this is not possible with current Smarsheet functionality.

    To get around this limitation, I'd consider a dropdown list with your named status types (e.g. Complete, On Hold etc.) and simply add in Conditional Formatting to change the cell fill based on the value.

This discussion has been closed.