Skip to main content

Column filters

Conditionally display rows based on column values

Use column filters to conditionally display rows based on the data inside one or more columns.

To apply column filters, follow these steps:

  1. Open the filter menu underneath a column header.

  2. Select a filter type and enter a search value, or use the checkboxes to select from the available column values.

Column filter types

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. Magic columns like Sign Offs have unique filters available.

Did this answer your question?