While it is wonderful that we now have the ability for custom colors on Dashboards, it would be truly helpful to also have this same ability in Sheets. It would be really helpful for some of our projects because our district uses certain colors to call attention to various district initiatives or our district instructional framework dimensions. Having the ability to customize the colors in sheets, as we can do now in Dashboards, would allow us to elevate our solutions for staff. Thank you for your time and consideration.
I second this idea! I have various projects that I use Smartsheet to help manage and being able to color coordinate the sheets would be extremely helpful in distinguishing the projects from one another.
It's such a basic thing we take for granted in every other app and has been requested hundreds, if not thousands, of times over the years. If they haven't seen fit to offer a basic color picker yet, I'm not sure they ever will.
Hello, Would it be possible to add the custom color option to the color choices within the sheet? It would be nice to be able to apply company specific colors to conditional formatting. Gantt chart task bars, rows, etc.
I second this idea. I have various projects that I use Smartsheet to help manage and being able to color coordinate the sheets would be extremely helpful in distinguishing the projects from one another.
2023-07-03T13:49:20.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":108420,"type":"idea","name":"User Management - Custom Job Categories","excerpt":"Allow entry of custom job categories. Add new fields to capture a user's business unit and department. These fields should also be included in all user reports. This functionality would be helpful for businesses that cross charge business units and depts for licenses and usage. ","snippet":"Allow entry of custom job categories. Add new fields to capture a user's business unit and department. These fields should also be included in all user reports. This functionality…","categoryID":349,"dateInserted":"2023-08-02T15:05:13+00:00","dateUpdated":"2023-08-02T15:07:21+00:00","dateLastComment":"2023-08-02T15:05:13+00:00","insertUserID":121864,"insertUser":{"userID":121864,"name":"Peggy Finley","url":"https:\/\/community.smartsheet.com\/profile\/Peggy%20Finley","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!upfCl_kNm74!24jE_y8s4qY!AEInjsEXdyc","dateLastActive":"2023-08-02T21:30:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":121864,"lastUserID":121864,"lastUser":{"userID":121864,"name":"Peggy Finley","url":"https:\/\/community.smartsheet.com\/profile\/Peggy%20Finley","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!upfCl_kNm74!24jE_y8s4qY!AEInjsEXdyc","dateLastActive":"2023-08-02T21:30:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":15,"score":2,"hot":3381978154,"url":"https:\/\/community.smartsheet.com\/discussion\/108420\/user-management-custom-job-categories","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108420\/user-management-custom-job-categories","format":"Rich","tagIDs":[238,247,265,363,549,550],"lastPost":{"discussionID":108420,"name":"User Management - Custom Job Categories","url":"https:\/\/community.smartsheet.com\/discussion\/108420\/user-management-custom-job-categories","dateInserted":"2023-08-02T15:05:13+00:00","insertUserID":121864,"insertUser":{"userID":121864,"name":"Peggy Finley","url":"https:\/\/community.smartsheet.com\/profile\/Peggy%20Finley","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!upfCl_kNm74!24jE_y8s4qY!AEInjsEXdyc","dateLastActive":"2023-08-02T21:30:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":247,"urlcode":"Contacts","name":"Contacts"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":549,"urlcode":"account-and-user-management","name":"Account and User Management"},{"tagID":550,"urlcode":"admin-center","name":"Admin Center"}]},{"discussionID":108376,"type":"idea","name":"Enable conditional formatting based on Critical Path items","excerpt":"When a row is on the critical path, I'd like to be able to set conditional formatting so that it turns text red, or colours the cells, so that it is a more obvious visual cue that this task is a particularly important one.","snippet":"When a row is on the critical path, I'd like to be able to set conditional formatting so that it turns text red, or colours the cells, so that it is a more obvious visual cue that…","categoryID":349,"dateInserted":"2023-08-01T19:48:07+00:00","dateUpdated":null,"dateLastComment":"2023-08-02T12:58:03+00:00","insertUserID":117033,"insertUser":{"userID":117033,"name":"Julian Sindall","url":"https:\/\/community.smartsheet.com\/profile\/Julian%20Sindall","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-02T12:56:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":117033,"lastUser":{"userID":117033,"name":"Julian Sindall","url":"https:\/\/community.smartsheet.com\/profile\/Julian%20Sindall","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-02T12:56:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":18,"score":1,"hot":3381901870,"url":"https:\/\/community.smartsheet.com\/discussion\/108376\/enable-conditional-formatting-based-on-critical-path-items","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108376\/enable-conditional-formatting-based-on-critical-path-items","format":"Rich","tagIDs":[363,437,439],"lastPost":{"discussionID":108376,"commentID":388453,"name":"Re: Enable conditional formatting based on Critical Path items","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388453#Comment_388453","dateInserted":"2023-08-02T12:58:03+00:00","insertUserID":117033,"insertUser":{"userID":117033,"name":"Julian Sindall","url":"https:\/\/community.smartsheet.com\/profile\/Julian%20Sindall","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-02T12:56:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":1}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"}]},{"discussionID":108333,"type":"idea","name":"vLookup: column name instead of number","excerpt":"When using the vlookup formula, is it possible to indicate the column name that we want to return as result instead of the column number? Cos sometimes the columns get reordered, and the results returned by column number will not be the intended column. This is especially so when we are referencing another sheet in the…","snippet":"When using the vlookup formula, is it possible to indicate the column name that we want to return as result instead of the column number? Cos sometimes the columns get reordered,…","categoryID":349,"dateInserted":"2023-08-01T00:34:26+00:00","dateUpdated":"2023-08-01T13:10:06+00:00","dateLastComment":"2023-08-01T12:30:34+00:00","insertUserID":66776,"insertUser":{"userID":66776,"name":"JamieLim","url":"https:\/\/community.smartsheet.com\/profile\/JamieLim","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-01T00:34:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":91566,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-03T13:45:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":43,"score":2,"hot":3381747272,"url":"https:\/\/community.smartsheet.com\/discussion\/108333\/vlookup-column-name-instead-of-number","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108333\/vlookup-column-name-instead-of-number","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":108333,"commentID":388175,"name":"Re: vLookup: column name instead of number","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388175#Comment_388175","dateInserted":"2023-08-01T12:30:34+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-03T13:45:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&dateInserted=%3E2023-07-03T13%3A49%3A20%2B00%3A00&type%5B0%5D=Idea&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":184,"limit":3},"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">