How do I share a report without having to share the sheet it's drawn from?


Probably a stupid question, but Im really stuck here as I want people to update a sheet without allowing them access to all the info contained therein.🤔

Best Answer

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 03/18/22 Answer ✓

    @Venn Cannon

    Then you have three options. Edit. Four options.

    • Premium App, Dynamic View
    • Premium App, WorkApps
    • I recently developed a (what I call), Dynamic View Light. It's pretty 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. I recently combined this with a structure for a client where they could add data that populate the main sheet, but it's not possible to edit the data.
    • As Amber suggested, Update Requests.

    Would any of those options work/help?

    Remember! 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!


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

    W: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.