How do i allow a user to see data on a report, without giving them access to the Master Data sheet
Hello,
I have a form that feeds data into a master sheet/grid. I have am automation that separates the data by teams. I have a specific report that that has the information pulled in from the main page and i tried to give somebody access to just that sheet but they cant view any of the data. The only way they saw any of the data is by me giving them access to the main/master sheet (which i don't want). How do i allow somebody to view a report without giving access to the master sheet. Any help is appreciated.
Answers
-
Hope you are fine, by using published repory also you can use apps like Dynamic View & workappa
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi @Suzy Schreiber,
@Bassam Khalil is correct, you can use Dynamic View and WorkApps, though if you don't have either of those applications you can still "publish" your Report. The help article below will walk you through the steps, but pay close attention to your settings if your Report contains any sensitive information as publishing can make your data visible to anyone with the URL:
https://help.smartsheet.com/articles/522078-publishing-smartsheet-items
