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

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…