Sharing a Report

Hannah McHardy

Hello,

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?

Thanks, Hannah

Bassam Khalil

Hi @Hannah McHardy 

Hope you are fine, please try to Publish the Report

Andrée Starå

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!

Best,

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!

Bassam Khalil

@Hannah McHardy

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 )

Hannah McHardy

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.

Hannah

Andrée Starå

@Hannah McHardy

Happy to help!

Glad to hear it's good, and it's the same for me.

• Would the other department need to update the information or only view it?
• Should their version continue to be updated from the main sheet?

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, andree@workbold.com)

Hannah McHardy

Hi Andree,

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.

Hannah