Sharing reports without sharing the source data sheet
Hi Smart Sheet Community,
maybe this question has been answered before but I couldn't find it in the forum.
I have a main data sheet and I want to share a report for easier collaboration with other departments in my company. Reports are great as they only show a selected set of columns and information without showing sensitive information that I don't want to share.
However, in order for the report to be editable for external collaborators, I seem to have to also share the source data sheet, which then makes all the sensitive information visible to all.
An alternative to keep the sensitive information from being shared, I know I can publish the report rather than share it. But then I have the issue that the team can not edit the report anymore...
Is there another way of sharing reports with a team without sharing the source report with sensitive information and keep the report editable for collaboration?
Thanks in advance