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.
Share reports without sharing entire underlying sheet
Hello,
I would like to understand the best process to, once a month, update a sheet with data from 2 partners. then I would like to share just that partners data with them for viewing and possilby updating.
is the best way a report on top of the sheet with a fitler? i tired this and it seemed that they could click through the the underlying sheet with access to all 20 partners data.
just learning .. thanks for the help.
-Scott
Comments
-
Hi Scott, what you seek is a very popular requirement and you are right that if you need to give your partner editing rights to the Report, you are also are giving them access to edit, the whole source sheet with confidential info contained.
Your choices are these....
Create reports that are View only which they can see in Real time if you publish them which avoids your partner logging in, they just have a link which can include Gantt if relevant. You also need to provide some means of them giving you feedback to "request and edit" from your team. A simple email, fill out a form?
You can automate the sending of a Report by PDF or Excel on a chosen day monthly (view only again).
OR...
by using Appsheet.com with Smartsheet you can privide your partners with a really rich interface UI on any device or platform, slice and Dice the data any way you wish and crucally for you, your partners will only see and edit what you wish them to.
We are helping lots of companies to implement this solution with variations and all the data is still kept in Smartsheet, google sheet, or Excel as Appsheet is just the "conditional logic engine" and the good news it is not expensive, but there is a cost.
Hope that helps?
RichardR
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives