Filter Columns as part of Filtering Options (not manually hide/unhide)

I would like to be able to use the "filters" feature at the top of the sheet, to filter columns, ie: "automatically hide/unhide columns", just like is available for the row filters.

We use this tool as a customer facing tool and I don't want to have to manually hide/unhide the "helper" and administrative columns. By being able to use the filters would alleviate the possibility of end customers seeing those administrative columns and allow them to focus on the actual information they need to see.

Sign in to vote!

Find more posts tagged with

Idea Submitted

columns

Filters

Comments

CBT

Would love the option to select the columns to be visible (vs hidden) when a specific filter is selected. I use filters to allow viewers to quickly see only the rows they want to see while still having the ability to expand and see all rows. The same would be nice with the columns. Still filter with rows, but select which columns to initially show/hide when the filter is selected.

adamhourigan

It would be ideal to have the ability to setup multiple views when working with several organizations /departments. We have a sheet that has 5 different organizations that will need to edit a task list and gant chart and would love the ability to have each org only be able to see their column and not all of the columns.

Marcela

Hello @adamhourigan,

Have you thought about creating two Reports from the same sheet? That way you can provide a filtered view with select column for each team/departments to work in. You can make changes to most cell data in a Report which then immediately is updated in the underlying sheet.

They would still need to be shared to the underlying sheet, but it would prevent the scrolling/hiding and unhiding that you're mentioning. 🙂

Quick Links

Trending ideas

Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Editable email Subject header from Smartsheet Notification
Hi There, I would like to propose that Smartsheet considers the email subject header that is received from a Smartsheet notification from a form or sheet. Currently, because not everyone in my company has Smartsheet, let alone a Smartsheet log-in, we need to send show the name of the owner of the sheet, that appears on the…