how to use report sheet without sharing the data source sheet?

Guilherme Ribeiro

it´s possible to have a report shared to a anyone without share the main sheet (data source sheet)

Thanks,

Andrée Starå

Hi Guilherme,

Yes, as a published read-only version or thru cell linking and reporting on the linked information.

Would that work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Alison

Hi there,

 

Another option would be to use it as a Widget on a Dashboard, where it essentially does the same thing as publishing (in that you do not need to share the underlying sheets) but you do not need to publish the item.  Here's some information on that.

 

I hope this helps!

 

Alison

Guilherme Ribeiro

Hi Andrée

Actually I would use the report sheet as "interface" for tasks updates directly into data source sheet. But I intended to make sure each users see only their tasks. I can do that using a report feature, but it wont work if I must share the data source sheet (they will have full access thru it)

sschreiner

@Guilherme Ribeiro did you ever figure out a solution to this? I am running into the same problem.

Jan Voříšek

https://community.smartsheet.com/discussion/40901/how-to-use-report-sheet-without-sharing-the-data-source-sheet

Hi everyone,

i am looking for the answer for the first question (quoted).

It is absolutely necessary to share report but keep the source data (in the sheet) secured and hiden. That should be the main goal of sharing reports.

Does final solution coming?

thank you very much in advance