Is there a list already generated for the 40 colors available for selection?
ie #FFF200 = Yellow
Craig
My tool is below. It isn't perfect some are a little off, but it works well enough.
Can I get a copy? That's exactly what I was looking for.
(craig.williams@ronin-global.com)
https://publish.smartsheet.com/4c6c77c86bef4bd497618dd59e14e717
Not a problem. I manually used a color picker to make this, so like I said it isn't perfect, but its close enough for my purposes
Thanks to Luke for getting me started.
I added this to my website:
http://ronin-global.com/color-codes/
This shows the hex codes and RGB values for the colors available in Smartsheet and other.
There's no commentary there, just the codes. The RGB values have been updated from what Luke provided based on the hex codes.
The values Luke provided and those on your site are just a 'little' off.
Here are the correct hex codes and corresponding RGB values:
https://app.smartsheet.com/b/publish?EQBCT=d074402ccb2b496fbbf5a4ba0dfba3eb
I assume you pulled those directly.
I'll update my webpage shortly. The order is different (I did row/column, Luke did column/row)
Yes, the hex I pulled directly. I didn't have the RBG however so that is calculated by the sheet.
I did the same (calc the RGB). I was going to pull from the API next time I was writing code.I updated my sheet with the correct values.
Thanks for the update.
I had several links (URLs) saved in a sheet for quick access to frequently used resources. All of the links (URLs) have disappeared. Many links were to Google Drive resources. What caused the links to disappear?
I have never had issues with conditional formatting, even when formulas were required. This one is simple, it is NO formulas, just based on the user's selection from a dropdown that appears in this sheet. The first screenshot shows the column example. Most are declined here, and those should be highlighted ORANGE based on…
I'm trying to create an automation. In this automation, I want to copy rows when a value changes based on a formula (a count from another sheet), but the automation isn't triggering. What could be causing this issue?