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
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!