Sign in to join the conversation:
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.
Here is a very simple automation which says that if a row is added or changed, and the value of Status is blank or 'On Hold', then change it to 'Backlog'. Now i add two rows, first has status blank, and second has status 'On Hold'. The automation changes the value of second row and not the first. Anyone has an idea why? Is…
Dear all, I have set up an automatic email notifications which should be sent once any cell of a row has been changed. The problem is that the email contains all columns and not only the columns with added or changed cells. Is there a possibility that only the affected columns (all columns which have been filled in and not…
Currently have a field in my sheet summary with this formula: =COUNTIFS(Finish:Finish, <=TODAY(+14), Finish:Finish, >=TODAY(), [Helper Parent Column]:[Helper Parent Column], <>"", Status:Status, <>"Complete") I would like to add if the Status is "Not Needed". How do I modify the formula?
