Filters and sorting

Narrowing a table to exactly the Entries you need: conditions, AND and OR groups, filtering by Links and Lists, and sorting.

6 min

Filters choose which Entries a table shows; sorting chooses their order. Both work on Hubs and Lists, on tables and boards, and both can be saved into a View.

Adding a filter

  1. Click Filter in the toolbar.
  2. Choose what to filter on — a Signal, a Link or a List.
  3. Choose the operator, such as is, contains or greater than.
  4. Enter the value. For is any of and similar, separate values with commas.
  5. Click Apply.

A dot on Filter shows a filter is active. Click Filter again to change it, or clear it from the chip under the toolbar.

The filter builder
Conditions can be combined with AND and OR groups.

Operators

OperatorMatchesWorks with
is, is notExactly this valueText, numbers, dates, choices, people, yes/no
contains, does not containText that includes thisText, email, phone, URL, long text
starts with, ends withText beginning or ending with thisText, email, phone, URL
greater than, at least, less than, at mostAbove or below a valueNumbers, currency, percentage, dates
betweenBetween two valuesNumbers, currency, percentage, dates
before, afterEarlier or later than a dateDates
is any of, is none ofOne of several valuesText, numbers, choices, people
has, has any, has allMulti-choice Signals holding these optionsMulti-select
is empty, is not emptyNo value, or any valueEvery type

Combining conditions

Add filter adds a condition that must also match (AND). + OR group adds a group where any one condition is enough. Groups can be nested three deep, with up to 32 conditions in a group.

Example — *open deals worth over SAR 100,000, or any deal in Negotiation*:

  • Value greater than 100000 AND Stage is none of Won, Lost
  • OR group: Stage is Negotiation

Filtering by Links

Filters can look across a Link:

OperatorMatches
has anyEntries with at least one linked Entry — People who have a Company
has noneEntries with no linked Entry — Companies with no People
isEntries linked to a particular Entry — People at Acme
has one whereEntries linked to one that matches its own filter — People whose Company's Industry is Real estate

Filtering by List

On a Hub, filter by a List with is on or is not on — "Companies that are not on Account Renewals". On a List, its own Signals, like Stage, can be filtered like any other.

Sorting

Click Sort, choose a Signal and Ascending or Descending. Add more sorts to break ties — Stage, then Value descending. The badge on Sort shows how many are set. Multi-select Signals cannot be sorted.

Searching a table

The Search Entries box in the toolbar finds Entries by name within the current table, on top of any filter. For everything else, use a filter.

Checked against Relio on 29 October 2026