Applies to
Capabilities
Who can use this capability
- Owner
- Admin
Dynamic View: Use filters to show subsets of data
Dynamic View allows you to save time by creating views that contain large data sets and shared filters —rather than having to create multiple, separate views to give people access to subsets of data. People who view the data can use the shared filters provided by the administrator or they can create their own filters to easily find and view the items they care about.
Who can use this?
Plans:
- Smartsheet Advance Package
- Smartsheet Gov
Permissions:
- Owner
- Admin
Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.
People with Owner or Admin permissions can create, share, and edit filters (they can also edit filters created by others). Anyone shared to the view can create and edit their own filters.
You can get access to the Dynamic View app with your Smartsheet account after someone has shared a view to you or if an Admin gives you access to the app. You can also set up a free trial account the first time you access the view.
Use filters in Dynamic View to find data that matches your specified criteria and quickly sort the results the way you want. With filters, you can:
- Quickly find subsets of data
- Easily get to the data you want each time you come back to the view
You can access the Dynamic View app from here.
Turn a filter on or off
- To apply a filter to a view, start from the view, and select the desired filter from the Filter menu.
- To clear a filter (stop applying it to the view), select Filter off.
You need to wait for all pages of the Dynamic View to load before applying a filter.
Create a new filter
From the Dynamic View app, start from the view for which you want to create a filter:
- Select the Filter icon in the upper-left corner of the view and then select New Filter to display the Filter window.
In the Name box, type a name for the filter. If you don't provide a name, the filter will be saved as Unnamed Filter.
If you're the view Owner or have Admin permissions to the view, you can specify to share a named filter so that anyone who is shared to the view can use it. To do this, select the Share Filter checkbox.
- Select the conditions that you want to use to filter to the data, and then select Apply.
That’s it! Your view will be filtered with the criteria you specify. If you gave your filter a name, you’ll be able to use it any time you visit the view. If you opted to share the filter (Owner or Admin only), anyone who has access to the view will now be able to use it.
For information on creating views and selecting columns, see Dynamic View App: Create and Administrate Views.
Clone an existing filter
If there are existing filters on the view that produce similar results to a new filter that you want to create, you can save time by cloning that filter.
- From the Filter menu, hover over the name of the existing filter and select Clone.
This will create a copy of the filter and open the Filter window. - Make any changes you want and select Apply to save the new filter.
Modify an existing filter
You must have Owner or Admin permissions to change a filter created by someone else.
From the Filter menu, hover over the name of the filter that you want to modify and select Edit.
Verify that the name of the Filter window matches the name of the filter that you want to edit to ensure that you’re modifying the correct filter.
- In the Filter window, update the conditions as desired and select Apply.
Delete a filter
From the Filter menu, hover over the name of the filter and select Delete. The filter is removed from the view too.