Shared report not showing all sheets


Hi Everyone,

I have an issue where I have a report that is combined from 9 individual engineer smartsheets. As the admin, I can see all 9 users sheets and the report looks correct.

However, when I emailed the report to my other email address to check it, the report shows only my own rows (because I shared my own sheet with my other email address). I double checked this by sharing another engineers sheet with myself, and that item now shows up on the report.

This seems completely insane that I would have to share EACH sheet with EACH user to allow a report to function correctly. Please tell me I'm wrong here.

I have to email this report to about 20 PM's and I want to avoid having to manually share each engineer sheet with EACH PM to allow access. Is there a way to set up the report so no matter who views it, they see the entire report and not just portions of it?

What my "user" sees (my other email address):



  • Andrew1983
    Andrew1983 ✭✭
    edited 05/18/21

    Edit - I realized after reading a couple posts why smartsheet does this, because if the person isn't shared onto the sheets that make up the report in theory they could change data on a sheet they don't have access to. I guess I answered my own question here.

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @Andrew1983

    I hope you're well and safe!

    Depending on your Smartsheet Plan, you could maybe use WorkApps. With WorkApps, they don't need to be shared to the underlying sheets.

    Would that help/work?

    I hope that helps!

    Be safe and have a fantastic day!


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

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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.