Summary Reports: No access to the base report

KellHobbs

Hi All

We have a sheet that has confidential information in it and I need some users to be able to access specific from the information and not others.

I thought a Summary Sheet may be the solution (they need to be able to export the data) BUT I do not want them to have access to the base sheet. This is where i am stuck.

Does anyone have any ideas how to get around this?

Thanks

Peggy Parchert

Hi @KellHobbs

You could publish the report and share the published link to the report with them. They can still export the data from the report but don't need access to the Source sheet.

https://help.smartsheet.com/articles/522078-publishing-smartsheet-items

Hope this helps.

-Peggy

Peggy Parchert

Hi @KellHobbs

You could publish the report and share the published link to the report with them. They can still export the data from the report but don't need access to the Source sheet.

https://help.smartsheet.com/articles/522078-publishing-smartsheet-items

Hope this helps.

-Peggy

KellHobbs

Thank you so much this solved my issue!