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.
Workaround for Editing a Report Without Full Access
I have a crucial missing piece to a workflow of mine which would allow my customers to edit my Smartsheet Reports in order to make their "selections" on my products.
The issue I'm having is that I cannot share the sheets associated with my reports with my customers because there is information on those sheets that I would not want my customers to see.
The only workaround I've thought of thus far has been to create a second sheet that has specifically the information I want my customer to see and to bring that information over using the cell linking feature. Then I would use that second sheet to create my report and I would then share that report with my customer.
The issue with this workaround is that it is awfully tedious and requires way too much maintenance.
I've been calling Smartsheet almost twice a week to try and come up with workarounds. The best case scenario would be if reports were editable even when someone is not shared on the source sheet but it doesn't sound like it will be offered in the near future and I'd imagine it would be quite a buildout since security would be a major sticking point on this feature.
I'm desperately looking for a workaround that I have not thought of yet.
Any suggestions would be awesome.
Thanks in advance for the help!