Is it possible to share a Smartsheet that has a locked default filter with someone else?

We want to share a Smartsheet with others, but we only want them to see certain parts. To do this, we created a filter and set it to be the default view for people with viewer access. However, when we tested this with a team member who had viewer access, they were able to exit the filter. We want to prevent the person who receives the Smartsheet from changing the default filter as we do not want them to see all of the information on the sheet. Is this possible? If so, what would be a solution for this?


  • Jason Tarpinian
    Jason Tarpinian ✭✭✭✭✭✭

    I'd recommend building out a dashboard and embedding a filtered report onto it, then share the dashboard with whomever. That way they will be able to see whatever filtered report you embed on the dashboard without sharing the underlying sheet. You could also publish reports, but I always advise against that as it can get out of hand without even trying.

    Smartsheet also has a premium app, Dynamic View, which is like reporting on steroids. It too can share data without sharing the whole sheet, but with a lot more bells and whistles.

    Jason Tarpinian - Sevan Technology

    Smartsheet Platinum Partner