Filter operator reference
See which operators are available for each column type, which operators do not require a value, and which columns cannot be filtered.
4 min readUpdated
The operator list in an advanced filter changes based on the column you select. The table below shows the available operators for each column type.
| Column Type | Operators |
|---|---|
| Text, Long Text, Email, Phone, Link | contains · doesn't contain · starts with · is · is not · text is · text is not · is empty · is not empty |
| Number, Rating, Progress | is · is not · > · >= · < · <= · is empty · is not empty |
| Date, Date & Time | is · is not · in the next · in the last · is between · is on or after · is after · is on or before · is before · is empty · is not empty |
| Person | is · is not · is assigned · is not assigned · contains · doesn't contain · starts with |
| Multi Person | Everything Person offers, plus contains all |
| Status | is · is not · text is · text is not · contains · doesn't contain · starts with · is empty · is not empty |
| Dropdown | Everything Status offers, plus contains all |
| Checkbox | is · is not |
| File | is empty · is not empty |
| Color | is · is not · is empty · is not empty |
| Timeline | is between · is after · is on or after · is before · is on or before · in the last · in the next · is empty · is not empty |
| Last Updated | person is · person is not · date is · date is not · in the next · in the last · is between · is after · is on or after · is before · is on or before · is empty · is not empty |
| Group (built in) | is · is not · text is · text is not · contains · doesn't contain · starts with |
| Name (built in) | contains · doesn't contain · starts with · is · is not · is empty · is not empty |
| Created By (built in) | is · is not · is empty · is not empty |
The Three Built-In Columns#
Group, Name, and Created By are always available in the filter column picker. They are not columns that you add to the board.
- Group filters items by the group they belong to.
- Name filters by the item's title.
- Created By filters by the person who created the item.
Operators That Take No Value#
The following operators do not require a value:
- "is empty" and "is not empty" for every column type that supports them.
- "is assigned" and "is not assigned" for Person and Multi Person columns.
When you select one of these operators, the value picker disappears because the condition is complete.
Dates Without Typing a Date#
Date operators support relative date options instead of requiring you to enter a specific date:
- Today
- Yesterday
- Tomorrow
- This week
- Last week
- Next week
- This month
- Last month
- Next month
The "in the last" and "in the next" operators require a number and a unit: Days, Weeks, or Months.
The is between operator can also define a date range, such as a specific period or a relative range.