Sheet Access List
Is there a way to export a list of all users that have access to a sheet. It doesn't appear so to me but I thought I would ask just in case I am missing something.
Best Answer
-
Excellent, thank you!
Answers
-
JP,
Request a sheet access report in the "More Actions" menu within the User Management section of the Smartsheet Admin Center. A .csv file will be emailed to you that includes all sheets in your account and all users shared to each sheet, among other data. Once opened in Excel, you can then either filter the list or create a pivot table to easily see the users assigned to any sheet in your account.
Hope this helps.
Guy
-
Excellent, thank you!
-
Is there a way to download the list of people that have access to a single Sheet?
One of our frequent use cases involves sharing a sheet globally with a large number of people. It is very difficult to scroll through the small pop-up window to confirm/audit access. There has to be a better way to check sheet access than pulling an 'Account' level report in User Management!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!