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:  

  1. Select Filter . 
  2. 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.
  3. 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.
  4. 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 or Show filter next to the filter name, then select Apply. An eye icon next to the filter's name indicates its status.

Delete ‌filters

To delete a filter, select Delete filter , then Apply.  

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.