I have three sheets assigned to three different users. They all have survey user rights for their respective sheets.
I’ve created three identical reports and assigned each report’s source to each user’s respective sheet.
I only want the user to see the data in the report sourced from their sheet. But each user can see the data in the other users’ reports.
Hope I’m not being thick. Have I missed a setting to ensure that a user who’s assigned access to a sheet can only see reports that source data from that sheet?
Thanks everyone