Report access without base sheet level access
Hi, I have a user that needs access to a report (which filters the data based on a parameter and only returns certain rows). However it doesn't seem like they can view it unless:
- I make the report public, which isn't an option as it contains sensitive data.
- OR I share the base sheet with all of the data with them, which isn't an option either
Am I missing something? Is there a better way to manage this? The only (bad) options I can come up with are:
- Use an index match formula to pull the values that match the filter criteria to another sheet and share that sheet with them (not ideal just because it feels a bit brittle)
- Copy my base sheet and have them run their process and data completely separate (but then I have to maintain two sets of forms/ sheets/ etc)
Thanks in advance!