Overview
Use column filters to conditionally display rows based on the data within a specific column.
You can view and apply column filters at the top of each sheet column. To view these, you’ll need to enable the Show column filters in the Filters menu.
Once enabled, you can see the column filters directly below each column header.
Column filter options
To filter a column, first decide on the filter type. Click the filter type button and select from the dropdown menu. If applicable, enter the text that you’d like to filter to.
Here are some of the common column filter types:
Column filter type | Description |
Contains | Filters to cells which contain the entered text anywhere in the paragraph |
Does not contain | Filters to cells which do not contain the entered text anywhere in the paragraph |
Starts with | Filters to cells which contain the entered text at the beginning of the paragraph |
Ends with | Filters to cells which contain the entered text at the end of the paragraph |
Equals | Filters to cells which exactly contain the entered text |
Does not equal | Filters to cells which do not exactly contain the entered text |
Is empty | Filters to cells which do not contain any text |
Is not empty | Filters to cells which contain any text |
Unique column filters
Some column filter types are unique to a specific column type. All magic columns have unique filters available. For example, the Tasks column has the additional filter options “My incomplete tasks” and “All incomplete tasks”.
You can also filter based on Request status and other attributes.
