Can Viewers hide or filter columns that don't pertain to them?

My team has a spreadsheet that is shared internally (editing access) and externally (viewing access only).

For the external partners that use the sheet with viewing access only, is there a way for them to hide or filter to the columns that pertain to them? They need to see all of the rows, but not all of the columns.

Appreciate the help!

Find more posts tagged with

Sheets

Sharing and Collaboration

Reports

Community Platform

Enhancement Request

Account and User Management

Comments

Mike Wilday

Have you considered creating a report? Reports will gather all the data but only the columns that you want them to see. Here is an article on Creating reports.

Amy Gratz

Thank you, there might not be a solve because in this case the external partner is a vendor who only has viewing access and many of them do not have smart sheet accounts yet. There are too many vendors for me to create custom report views for them so this might be a "tough luck, just ignore what you don't need situation". Was hoping to please everyone though.

Lisa

If your sheet has an assigned to column, then you can create one report that has Assigned To "current user" as one of the criteria.

Each of your vendors would have to have a Smartsheet login to implement this solution, however.

Sign in to join the conversation!

Quick Links

Trending discussions

SUmmary in Report Widget
How can i create a Report widget that only shows a status with "red status" from my main data source? Do i need to create a separate data source on just my "red status"
Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…