Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Export List of People a Sheet is Shared With?

Is there a way to export a list from a sheet that shows the user's security level? And if so, can this list be imported to a new sheet so that each team member does not have to be added manually to the new one?
Β
Β
This is not necessarily for a template that is used repeatedly. It is a group of about 150 people, various combinations are common for most projects that I track. This would save a huge amount of time if available. As it is now, I have to take screen shots, which seems very inefficient.
Β
Even if it is not possible to apply the shared list to a new sheet, just having an Excel copy would prevent the need to take a screen shot of every five team members and would save time.
Comments
-
Jess,
Β
This might get you more than half-way there.
If you are Β a SysAdmin, in the upper left under Account | User Management, there is a More Actions button
Β
One of the actions is Download Sheet Access Report. This is a csv and can be imported straight into Smartsheet or opened in Excel/OpenOffice.
Β
Craig
-
Craig,
Thanks a bunch! I chose the Download User List and it is exactly what I was looking for. Also, from that same screen it looks like you can import too. I am definitely going to play with that and see if I can get a spreadsheet to load. This will save me hours of busywork!Β
Thanks again,
Jess
-
Jess,
Β
Glad I could help.
The list only shows sheets and reports that are in the account.
If you (personally) are shared to a sheet in another account, it won't show that.
Β
Craig
-
All I care about are the sheets that I own that are shared with a set of users. If those users are reflected in that export, I am good to go. Is that what you mean?
-
Jess.
Β
The report will show what you are looking for then.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives