Custom Tile Colors Calendar App - Not Dropdown for Report
LydiaR12
✭
When pulling from a report to create a calendar the column type needs to be a dropdown to assign custom colors. When pulling from a sheet it doesn't have to be a dropdown. This is not documented anywhere. Please make it so what you can do with custom colors in a calendar from a sheet can also be done with a report.
Tags:
Categories
2023-06-28T04:37:40.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":108187,"type":"idea","name":"Cell-level Comments","excerpt":"Cell-level comments would be a huge time saver (similar to Excel) and in the Comments feature bar there could be a tab at the top that reads \"Cell\" next to the \"Row,\" \"Sheet,\" and \"All\" tabs. Currently, I'm spending a lot of time describing columns and going back and forth on communication to confirm columns and which…","snippet":"Cell-level comments would be a huge time saver (similar to Excel) and in the Comments feature bar there could be a tab at the top that reads \"Cell\" next to the \"Row,\" \"Sheet,\" and…","categoryID":349,"dateInserted":"2023-07-27T15:06:03+00:00","dateUpdated":"2023-07-27T15:07:29+00:00","dateLastComment":"2023-07-27T15:06:03+00:00","insertUserID":149231,"insertUser":{"userID":149231,"name":"akrenek","title":"","url":"https:\/\/community.smartsheet.com\/profile\/akrenek","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2xdR_9Da37w!79DQu8jiP5Q!QvtbcEBDHfV","dateLastActive":"2023-07-27T16:33:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":149231,"lastUserID":149231,"lastUser":{"userID":149231,"name":"akrenek","title":"","url":"https:\/\/community.smartsheet.com\/profile\/akrenek","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2xdR_9Da37w!79DQu8jiP5Q!QvtbcEBDHfV","dateLastActive":"2023-07-27T16:33:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":17,"score":5,"hot":3380942312,"url":"https:\/\/community.smartsheet.com\/discussion\/108187\/cell-level-comments","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108187\/cell-level-comments","format":"Rich","tagIDs":[319,363,391,441,507,566],"lastPost":{"discussionID":108187,"name":"Cell-level Comments","url":"https:\/\/community.smartsheet.com\/discussion\/108187\/cell-level-comments","dateInserted":"2023-07-27T15:06:03+00:00","insertUserID":149231,"insertUser":{"userID":149231,"name":"akrenek","title":"","url":"https:\/\/community.smartsheet.com\/profile\/akrenek","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2xdR_9Da37w!79DQu8jiP5Q!QvtbcEBDHfV","dateLastActive":"2023-07-27T16:33:12+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":5}],"tags":[{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":441,"urlcode":"comments-and-conversations","name":"Comments and Conversations"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"},{"tagID":566,"urlcode":"idea","name":"idea"}]},{"discussionID":108153,"type":"idea","name":"Controlled data: Create Rows but not Edit OR Edit Rows but not Create","excerpt":"prevent accidental edits and maintain data integrity by allow users to create but not edit fields. or to stop duplicate fields from being created, grant users the ability to edit but stop them from creating new ones.","snippet":"prevent accidental edits and maintain data integrity by allow users to create but not edit fields. or to stop duplicate fields from being created, grant users the ability to edit…","categoryID":349,"dateInserted":"2023-07-26T23:06:59+00:00","dateUpdated":"2023-07-27T11:50:10+00:00","dateLastComment":"2023-07-27T11:53:06+00:00","insertUserID":81486,"insertUser":{"userID":81486,"name":"Trish Dillon","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Trish%20Dillon","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ejFZp_HtGHw!wf9YcMXtCfo!EieK1GzsuNz","dateLastActive":"2023-07-27T17:04:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-07-27T19:04:19+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":28,"score":1,"hot":3380872505,"url":"https:\/\/community.smartsheet.com\/discussion\/108153\/controlled-data-create-rows-but-not-edit-or-edit-rows-but-not-create","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108153\/controlled-data-create-rows-but-not-edit-or-edit-rows-but-not-create","format":"Rich","tagIDs":[219,363],"lastPost":{"discussionID":108153,"commentID":387483,"name":"Re: Controlled data: Create Rows but not Edit OR Edit Rows but not Create","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387483#Comment_387483","dateInserted":"2023-07-27T11:53:06+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-07-27T19:04:19+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":108141,"type":"idea","name":"Automatically Update Numbers in Countdown Formula","excerpt":"Currently, I have to refresh every day I need to see the most up-to-date number of days remaining for an event. I'm surprised this doesn't exist already considering how many tools there are for event and project launch coordination.","snippet":"Currently, I have to refresh every day I need to see the most up-to-date number of days remaining for an event. I'm surprised this doesn't exist already considering how many tools…","categoryID":349,"dateInserted":"2023-07-26T20:05:36+00:00","dateUpdated":null,"dateLastComment":"2023-07-27T11:38:35+00:00","insertUserID":164136,"insertUser":{"userID":164136,"name":"mp_12","url":"https:\/\/community.smartsheet.com\/profile\/mp_12","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-26T20:02:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-07-27T19:04:19+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":24,"score":3,"hot":3380861351,"url":"https:\/\/community.smartsheet.com\/discussion\/108141\/automatically-update-numbers-in-countdown-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108141\/automatically-update-numbers-in-countdown-formula","format":"Rich","tagIDs":[219,319,334,363,391,440],"lastPost":{"discussionID":108141,"commentID":387478,"name":"Re: Automatically Update Numbers in Countdown Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387478#Comment_387478","dateInserted":"2023-07-27T11:38:35+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-07-27T19:04:19+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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":3}],"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&dateInserted=%3E2023-06-28T04%3A37%3A40%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":170,"limit":3},"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
