Best Practice: Sharing a Report
I have several sheets that contain course development information. Some of the information is private and not intended to be shared .
I created a report for a vendor that pulls information from one sheet (and that one sheet pulls data from 4 or 5 other sheets).
Our goal is for the vendor to update the Status column in the report for each course, so that status update appears in our main sheet. The report only has columns that are important for the vendor to see.
However, I shared the report, and the vendor sees nothing. I am guessing this is because the vendor does not have access to the supporting sheets.
I read that I could hide the columns in the main sheet so the vendor cannot see them if she were to open the sheets. But this is not a good practice because my team whose access to all of the sheets, will be making updates as well, and will need to have columns unhidden.
Has anyone used an approach to share a report without sharing the sheets if shared preventing the person for whom the report is created from seeing private information in the supporting sheets?