Customizable Permissions
Often times I find that I need to give further permissions to users, but don't want to give them unfettered access to sheets. Often times my Project Managers need to add an additional item to a drop-down menu, add an additional column to track a specific need, reorder columns to fit their needs, or adjust lanes in card view. All of these changes require Admin access, but don't effect existing reports/dashboards that are created. My request is either the ability to create custom permission levels or create an additional permission level that allows changes that don't effect reports (ie: deleting columns, changing column types, renaming files, adjusting other's permissions).
Tags:
Categories
2023-07-03T00:43:41.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":11,"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":16,"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":41,"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-03T00%3A43%3A41%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":187,"limit":3},"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
