How can I share a report without sharing the sheet.
**Translated via Google Translate**
Hello, good morning everyone.
On a sheet there is the information of all the sales, I need to share information with each client exclusively about their purchase, it is very practical to generate reports with said information, however when sharing it, the sheet must also be shared, which although it maintains the information hidden and blocked, when shared, the possibility of exporting is open and when doing so, for example to Excel, the option to show is enabled and in this way the entire matrix (information) is visualized.
Best Answer
-
Hola @Jose Vargas
Hay algunas opciones a considerar. En primer lugar, ¿tiene licencia para Dynamic View? En segundo lugar, si el usuario está configurado con una licencia de Smartsheet, el informe podría filtrarse como "usuario actual".
En tercer lugar, sería posible crear un informe único por usuario, filtrado para ellos, colocado en un panel publicado (un panel por cliente/usuario).
Puede leer sobre la vista dinámica aquí: https://help.smartsheet.com/learning-track/integrations-and-add-ons/dynamic-view
**Translated via Google Translate by a Moderator as the Community is only supported in English at the moment**
There are a few options to consider. First of all, are you licensed for Dynamic View?
Second, if the user is set up with a Smartsheet license, the report could be filtered as "current user."
Third, it would be possible to create a single report per user, filtered for them, placed on a published dashboard (one dashboard per customer/user).
You can read about dynamic view here: https://help.smartsheet.com/learning-track/integrations-and-add-ons/dynamic-view
Answers
-
I would very much appreciate if any of you can guide me on how to share a report without that user, in the manner expressed above, having access to all the information contained in the sheet, or perhaps you can tell me how else this situation can be overcome?
-
Hola @Jose Vargas
Hay algunas opciones a considerar. En primer lugar, ¿tiene licencia para Dynamic View? En segundo lugar, si el usuario está configurado con una licencia de Smartsheet, el informe podría filtrarse como "usuario actual".
En tercer lugar, sería posible crear un informe único por usuario, filtrado para ellos, colocado en un panel publicado (un panel por cliente/usuario).
Puede leer sobre la vista dinámica aquí: https://help.smartsheet.com/learning-track/integrations-and-add-ons/dynamic-view
**Translated via Google Translate by a Moderator as the Community is only supported in English at the moment**
There are a few options to consider. First of all, are you licensed for Dynamic View?
Second, if the user is set up with a Smartsheet license, the report could be filtered as "current user."
Third, it would be possible to create a single report per user, filtered for them, placed on a published dashboard (one dashboard per customer/user).
You can read about dynamic view here: https://help.smartsheet.com/learning-track/integrations-and-add-ons/dynamic-view
-
Hola Scott. Muchas gracias.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!