Advanced filters
Build precise filter conditions using And/Or logic and nested groups.
3 min readUpdated
Advanced filters let you build filter conditions explicitly instead of selecting values. The panel is headed "Advanced filters" and shows "Showing X of Y items" along with a "Clear all" option as you work.
Building a Condition#
- Select "+ New filter" to add a condition row.
- Select a column, then an operator, and then a value.
- Add more conditions the same way. The first condition starts with "Where". Each additional condition starts with "And" or "Or", which you can switch as needed.
Some operators do not require a value. For example, when you select "is empty", the value picker disappears.
Groups#
Select "+ New group" to add a dashed box containing its own conditions and "+ New filter" option.
The connector on the group switches between "And group" and "Or group", allowing you to create conditions such as: "status is Stuck, and either owner is empty or the due date is in the last 7 days".
When no filters have been added, the panel shows "No filters applied. Click "+ New filter" to add one."
Select "Switch to quick filters" in the footer to return to the value grid.