Split sheet to protect sensitive data

Man Chui

Currently, I have a workspace with sheets & reports but not everyone can access due to sensitive data. I've created a report & grant access to the user.

Noticed that, the report will show empty because user didn't have access for the workspace.
May I ask for help on how to manage on such ?

a.) We don't want to share the workspace & the source sheet to user.
b.) Just want to pull some specific items from the sheet.

The important is the source sheet covered everything & we need live update function.

Thanks a lot.

Paul Newcome

This functionality can be achieved using the premium add-on Dynamic View. Unfortunately, that is the only option that will work exactly as you have outlined here.

Andrée Starå

https://community.smartsheet.com/discussion/138289/split-sheet-to-protect-sensitive-data

Hi,

I hope you're well and safe!

Here's a possible workaround or workarounds

• Premium App, Dynamic View
• Premium App, WorkApps
• I recently developed a (what I call) Dynamic View Light. It's quite advanced, but in short, it uses cross-sheet formulas, INDEX/MATCH, and a specific structure and method, so it can only show data that should be available.

Would any of those options work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!