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
Options
SarahG
✭
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!
Tags:
Comments
-
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.
