Reports & Proofing to Person outside Organisation

Emmet McKenna

Hello, we are outsourcing some drawing to a freelance CAD Technician outside our organisation. I have setup a Report that has a number of source sheets and have added a checkbox column in the source sheets if the drawing is to be outsourced. When checked that item shows up in the Report (for all internal organisation users). The problem is the report is showing blank for the freelance technician. Is this because the source sheets aren't shared with them? I don't want sharing source sheets directly as they contain some confidential info. Is there a way to fix this or if not is there a some workaround?

Andrée Starå

Hi @Emmet McKenna

I hope you're well and safe!

There are some options.

What Smartsheet Plan do you have?

• If you have Enterprise or higher, WorkApps could be an excellent solution.
• Dynamic View

https://www.smartsheet.com/product/dynamic-view

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

Would any of those options work/help?

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!

Emmet McKenna

Hi Andree,

Hope you are keeping well!

We only have Business licenses at present (I assumed Enterprise was the highest plan available). You're Dynamic View Light sounds interesting, are you able to show attachments and proofs using this method?

Thanks, Emmet

Emmet McKenna

Hi Andree, just checking if you have any further info on the above solution to our proofing issue? Thanks.