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




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!


Andrée Starå

Workflow Consultant @ Get Done Consulting

In reply to by Andrée Starå

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)

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!