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.
Anonymous sharing to users without publishing
I'm looking for a workaround for a problem with sharing a sheet and its attachments with several non-licensed users. The situation is that whilst the collaboration features in Smartsheet are great when we are working within our team, they are problematic when it comes to sharing the information.
We need to give several new users viewer access to a sheet, but they should not be able to see who the other users are that the sheet is shared to. If we simply create new users with Viewer access, the problem is that they can still see who all the other collaborators are on the sheet. The only workaround I can think of at the moment is to save the sheet as a new sheet for each new user, and then share that sheet only to that user. This works, but it has a number of pitfalls:
* Any updates or changes to the original sheet need to be replicated on all the copies.
* Each sheet copy creates a copy of all the attachments which thus adds to the usage quota unnecessarily.
As workarounds I have thought about sharing a separate report for each user which would avoid replication of data storage and would also reflect any and all changes made to the original sheet. However this doesn't work because the new user will only see data from sheets they have been shared to, and unless I give them access to the original sheet, they won't see anything.
I've also tried cell linking to create copies of the original sheet, but I can't link to the attachments etc., only the cell contents.
What I really want is one of two options:
1) Ability to share a sheet to a user with 'Anonymous Viewer' rights. This would allow them to see the contents of a sheet as a Viewer, but they would not be able to see who else the sheet is shared to. I suspect this might be quite easy to implement, but of course is not available at the moment.
2) Publish the sheet so that only a shared user can see the published version of the sheet, but still requires to login to gain access (e.g. not just a public URL).
Any ideas on how to implement anonymous sharing?