How to share reports/dashboards with the filter on Current User, without sharing the source sheet?



I'd like my team members to have access to HR information in a Dashboard, but only info concerning them (current user) should be displayed.

I created a sheet, no one but me, has access to, listing all my team members. Then, I created a report and added a filter "Team member - Has any of - Current User". Finally, I created a dashboard and added this report to it.

But because they don't have access to the source sheet, they can't see the report (even if in a Workspace they have access to), nor the Dashboard.

Is there a way to give access to a report/dashboard with this filter, without giving access to the source sheet? The idea is to maintain only 1 sheet with all the HR info and 1 report, and not one for each team member.

Thanks a lot!

Best Answer