Print Dynamic View

2023-07-03T11:09:33.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":14,"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-02T18:59:20+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-02T18:59:20+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-03T11%3A09%3A33%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":185,"limit":3},"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">