We utilize hundreds of sheets for across our 15 locations and every time we add a new team member, they must be manually given sheet permissions- which can be upwards of 50 sheets per person. I would love to have a way to provide a new user the same permissions as another user. It would be much quicker and would guarantee no sheet permissions are missed for the new user.
Have you explored using Groups yet? If you share Smartsheet items to a Group of contacts, then all you would need to do is add a new email address / account to that Group and that account would be automatically shared across all the same items with the same permissions as the other members of the Group.
We do use groups, but not all employees need access to all the sheets in our groups. In our largest program, for example, the handful of us who built, piloted, and now manage the program's sheets are part of the actual group. The majority of people who are using sheets in that group only need access to a handful of sheets, not the entire program- There is sensitive employee information contained throughout that needs access to be restricted.
We could restructure everything into different groups, but that would be an absolutely massive undertaking.
2023-06-28T17:03:53.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":21,"score":6,"hot":3380942612,"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":6}],"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-28T16:16:46+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-28T16:12:26+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":30,"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-28T16:12:26+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-28T16:12:26+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":25,"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-28T16:12:26+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-28T17%3A03%3A53%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":[]}">