How do i allow a user to see data on a report, without giving them access to the Master Data sheet

Suzy Schreiber

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.

Bassam Khalil

Hi@Suzy Schreiber

Hope you are fine, by using published repory also you can use apps like Dynamic View & workappa

John Pudar

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