Filters can change what data displays on a grid, worksheet, or board based on conditions you specify.
When you filter a column or row, the grid updates to display the data items that match the filter condition. For example, you might want to show only salaries up to a specified sum instead of those for the full workforce.
You can apply filters to all data types. Filter conditions differ depending on the data type in the column.
Add a filter
To add a filter:
- Select Filter .
- On the grid, select the column or row you want to filter.
A new filter displays at the top of the Filters panel. The title of the column or row is automatically added as the filter title. - Select a filter option from the Select condition dropdown.
You can select Add to the right of the condition's value field to add more conditions. - Select Apply.
Note: When you filter a list, you can only select one item as the filter condition. The dropdown list displays the first 50 list items. For lists containing more than 50 items, enter a search term in the list field.
Enable or disable a filter
To enable or disable a filter, select Hide filter
Delete filters
To delete a filter, select Delete filter
To delete all filters and display a grid in its original state, select Remove all filters. Then in the Remove all filters dialog, select Remove all filters.