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.
Sharing Multiple Sheets with a User at Once

Is it possible to share multpile sheets with a user at once? Β I have several sheets that I would like to make accessible to one of our users, and the only way I know of to do this currently is to go into each sheet and share one at a time. Β Is there a faster way to do this? Β Also, can I quickly view who is currently shared on all of the sheets from a single view?
Comments
-
The only other way is to place them all in a workspace and share the workspace. This will very much depend on what access permissions you want others in the workspace to have. Β Remember whatever permisions you give people to the workspace they have those permissions on all the sheets in it.
-
Hello! As James suggested, workspaces can be used but it may not work for your situation.
Β
Another option for Team and Enterprise accounts is to use groups. This would require initial set up, but would be a quicker way to share multiple sheets in the future.
Β
If you have a group of sheets that you want to share to users, create a group and share the sheets with that group. Then, whenever you add a user to that group, they will be automatically shared to all the sheets shared to the group.
Β
Again, this would require initial set up (sharing all the sheets to the group) but it could save you time in the future.
Β
Here's information on groups:Β http://help.smartsheet.com/customer/en/portal/articles/1554165-managing-groups-team-enterprise-only-
Β
As far as seeing who is shared to sheets, SysAdmins on Team and Enterprise accounts can download a Sheet Access Report. Here's information on how to do this:Β https://www.smartsheet.com/blog/support-tip-user-access-report
-
Thanks for the replies. Β The workspaces solution solved my issues. Β The groups idea will also be helpful in the future.
-
Travis -Β I know this was a post from days gone by, but it did educate me on how to use groups.Β Very useful when sharing multiple sheets to a group of usersΒ (that often changes!).
Β
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