Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Enhancement Request - Filter Columns
I believe it would be greatly beneficial to be able to filter columns as well as rows.
The saved filter profiles was a great enhancement that allows sheets that are used for data tracking to be sorted to data subsets. If you could also save which columns are to be displayed to the filter profile then you could create views for specific stakeholder types. For example, on a sheet that tracks project metrics with each project having its own row, some groups may be interested in only a subset of the data. Coordinators, for example, may want to see only the the columns related to project status and dates, while business managers may want to see only the columns showing financial performance data.
This concept could be further improved by setting viewing permissions to a specific filter when sharing. For example, when you share the smartsheet with a coordinator they can only view the "coordination filter" whereas the manager could only view the "manager filter". You may have a limited public view of the project for "customer filter". This would allow the data to be stored in a common sheet, but ensure that stakeholders don't access fields that might otherwise be confidential.
Comments
-
+1. Column filters would be a hugh enhancement to my workflows in Smartsheet.
-
Hello All—
I've got your votes down for a column filter feature on our enhancmenet request list for further consideration by our Product team.
With that being said, you might consider creating a report and including just the desired columns in the report. More on reporting can be found in our Help Center: https://help.smartsheet.com/articles/522214-creating-reports
