I have created a report from master employee data. I want to share the report to another department that doesn't have access to the master data (for confidentiality reasons). How do I do this?
Hi @Hannah McHardy
Hope you are fine, please try to Publish the Report
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Hi @Hannah McHardy
I hope you're well and safe!
What Smartsheet Plan do you have?
I hope that helps!
Be safe and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET PARTNER & CONSULTANT / EXPERT
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
And if you want to use something more proficinal to control your sharing permission. you can use Dynamic View Or Workapps applications. ( You need to pay for those applications extra cost )
Hi @Andrée Starå,
Yes all good here in New Zealand. I hope the same for you.
I am a (business) licensed user with Data Shuttle and Pivot add ons, we wont be adding on any other apps. Seems crazy that I cant share a Report with another department for them to work on, such is life I suppose. I might export to excel/csv and then get the other dept. to setup a new data shuttle workflow for their purposes, or do you think thats the wrong thing to do?
Thanks for your advice in advance.
Happy to help!
Glad to hear it's good, and it's the same for me.
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])
Thanks for getting back to me.
Let me try explain the situation - I work in the HR dept and run a master data sheet with all employee information, including emergency contact information. Our internal Risk dept, needs this information for disaster recovery procedures but we cant share the whole sheet because it contains confidential information. We are constantly going back and forward confirming new/leaving employees and their details, when it would be easier if they had access to the relevant columns from our master data live. Once the Risk dept have this information, they want additional columns for their own purposes.
To answer your questions clearly - First Q - No, the Risk dept wouldn't want to update the information we share to them, but they would add additional columns for their own purposes. Second Q - Yes, we want their version to update from our master data.
Thanks so much for your help.