Filter, sort and save a view

Filter on any column, join conditions with and or or in groups, sort, choose the columns, add a sum or an average under a column, save it all as a view for you or the whole team, and group views in folders.

For foundersUpdated Nov 7, 2026

The two lines above every table and board in the CRM, on All contacts and on each type, hold every way to narrow it down. The first has the view's name, Columns, Search by name and Board, Table or Dashboard. The second has Sort, the filters, and Discard changes and Save view when the view has changes. Every column you can show can also be filtered.

Add a filter

  1. Choose Filter in the bar. A panel opens with the conditions of the view.
  2. Choose Add condition and pick a field. Type in Filter by to find one, or use the arrow keys and Enter. The fields come in groups:
    • Contact: Name, Kind, Type (on All) and every contact field.
    • One group per type, with its Stage and its own fields. On All, a condition like Investors › Check size means "is in Investors and their check size is...". On a type, only that type's group shows.
    • Activity: Last contacted, Next step due, Created, Updated and Notes, and on All the soonest Next step across a contact's types.
    • A field that links to other contacts, like Company or People, opens a second list with the linked contact's fields: Company › Location finds people whose company is in Tokyo.
  3. The condition shows as a row with three parts: the field, the condition and the value. The value opens at once: pick or type it, and press Enter. A condition left with no value goes when you close the panel.

Click any part of a row to change it, and its cross to remove it. The foot of the panel says how many rows match. Once a filter is on, the button reads Filtered by and the number of fields, like Filtered by 2 fields. In a table, a column's name also has Filter on this field, which opens the panel with a condition on that column.

Conditions

Each kind of field has its own conditions:

  • Text, emails, phones and links: contains, does not contain, is, is not, starts with, is empty, is not empty.
  • Numbers and amounts: equals, is not, is less than, is at most, is more than, is at least, is between, is empty, is not empty. Amounts take 250k or 1.5M.
  • Dates, and Created, Updated and Last contacted: is today, is in the last, is more than (some time ago), is in the next, is before, is after, is between, is empty, is not empty. The relative ones take a number and days, weeks or months, like "is in the last 14 days" or "is more than 3 months ago".
  • A choice or a stage: is, is not, is any of, is none of, and for a choice is empty or is not empty.
  • Several choices, and Type: has any of, has all of, has none of, is empty, is not empty.
  • Kind: is Person or Organization.
  • Linked contacts, like Company or Intro by: is any of, is none of, is empty, is not empty.
  • Notes: contains and does not contain look in every note; is empty means no note yet.

Relative dates follow your own time zone, so "is today" is your today. A saved view keeps the rule, not the dates: "in the last 14 days" stays the last 14 days.

And, or and condition groups

  • The first condition starts with Where. The second has a menu where you pick and (every condition must be true) or or (one is enough); it joins every condition of the set.
  • Add condition group adds a grey box of conditions with their own and / or, like "Stage is Term sheet or Committed". Its first line says Any of these is true or All of these are true. Add condition inside the box adds to it. A group cannot hold another group.
  • Clear all removes every condition.

A view takes up to 20 conditions.

Sort and columns

  • Choose Sort and pick Name, Last contacted, Created, Last updated or any field, then Ascending or Descending. With no sort, All shows the last changed first, and a type the newest first. A column's name also has Sort ascending and Sort descending.
  • Choose Columns (in a table) or Fields (on a board) and switch on what each row or card shows. See Edit the CRM table like a spreadsheet.
  • Type in Search by name, and on a type switch between Board and Table. Every view shows either way: the CRM keeps the one you picked last. Dashboard shows a type or All as charts instead: see See your CRM and tables as charts.

Count and calculations

The last row of a table stays at the bottom while you scroll. Under Name it shows how many rows the view and the search match, all of them, not only the rows on the screen. More rows load by themselves as you scroll down.

Under any other column, choose Add calculation and pick what to show:

  • Every field: Filled, Empty, Percent filled, Percent empty, and for text, choices, numbers and dates Unique (how many different values).
  • Numbers and amounts: Sum, Average, Median, Min, Max. Amounts in several currencies show one figure per currency.
  • Dates, Created, Updated and Last contacted: Earliest and Latest.
  • Checkboxes: Checked and Unchecked.

Choose the calculation again to change it, or None to take it away. Calculations save with the view, like its columns.

Views

Each type has its own saved views, and All contacts has its own. Choose the view's name at the start of the bar, like Investors / All 12, to list them under the types, each with how many contacts it matches:

  • Team views are shared with everyone in the workspace. Only me views are yours alone.
  • Click a view to open it. The CRM opens on the view you used last.
  • Type in Find a view to find one by name.
  • Drag a view up or down to change the order. Workspace admins order the Team views; everyone orders their own.
  • Folders hold views, like Source LinkedIn with Engaging and Refused in it. See Group views in folders.
  • The same menu opens on a phone's browser.

Make a view

  1. Choose New view at the bottom of the menu, or New view in this folder in a folder's ... menu.
  2. Type a name. To share it, tick Shared with the team: only workspace admins see this box.
  3. Choose Create. The new view starts with no filters: add the filters and sort you want, then Save view. It shows as a table or a board, whichever you pick in the bar.

Save changes

When you change the filters or the sort, an orange dot shows beside the view's name in the menu, and Discard changes and Save view show at the right of the second line.

  • Discard changes puts the view back as it was saved.
  • Save view keeps the change in the view you are on, when it is yours or, for workspace admins, shared with the team. Otherwise it asks for a name and saves a new view.

Rename, duplicate, share or delete

Hover over a view and choose its ... menu:

  • Rename, or double-click the view's name. Press Enter to keep the new name.
  • Duplicate makes a copy with the same filters, sort and columns. On a team view you cannot change, it is Duplicate as my view.
  • Shared with the team (workspace admins): tick it to share your view with everyone, untick it to make a team view yours alone.
  • Move to puts the view in a folder of its kind (a team view in a team folder, your own in your own), and Move out of takes it out.
  • Delete view removes the view, never the contacts in it. Each type keeps at least one team view.

The columns you show, their order, their width and their calculations save by themselves. A view shared with the team changes only for workspace admins; for anyone else, column changes last until they leave the page, and Save view keeps them as their own view.

Group views in folders

A folder holds views and has a filter of its own, which every view in it shares. A folder Source LinkedIn with the filter "Platform is LinkedIn" can hold Engaging, Refused and Signed up: each of them shows only LinkedIn contacts, then adds its own filter, like "Stage is Engaging".

  1. Choose New folder at the bottom of the menu, type a name and choose Create. Workspace admins can tick Shared with the team.
  2. The folder opens like a view. Add the filter its views share, like "Platform is LinkedIn", and choose Save view.
  3. Put views in it: drag a view onto the folder, choose Move to in the view's ... menu, or New view in this folder in the folder's own menu.
  • The folder's filter shows under its name in the menu and, when one of its views is open, in the second line beside Filter, with a folder icon. The view's name then reads like All contacts / Source LinkedIn / Engaging. The filter cannot be changed from there: click it to open the folder and change its filter. Every view in the folder follows.
  • Click the arrow beside a folder to fold it shut or open it again. Each folder shows how many contacts its filter matches.
  • Duplicate on a folder copies it with every view in it. Rename the copy, like Source X, change its filter to "Platform is X", and the same views now work for X.
  • Sharing a folder, or making a team folder yours alone, takes its views along.
  • Delete folder keeps its views: they move out of it, below your other views, and stop using its filter.
  • Save view on a team view in a folder, for someone who cannot change it, saves a view of their own with the folder's filter added to its own, so it shows the same contacts.

On the phone

In the phone app, tap Filters, the first chip in the row under the search on the CRM tab. It opens Filter and sort, which sets the same rules, joined by and or or, and the same sorts. The chip shows how many filters and sorts are on. View picks a saved view, team views first, each with how many contacts it matches; a view in a folder shows as "Source LinkedIn / Engaging". The ... beside it renames, duplicates, shares, moves to a folder or out of one, or deletes it, and has New folder (and New view in this folder on a folder). A view in a folder shows the folder's filter above its own: tap it to open the folder. A rule on a date picks its day with Pick a date. Views saved on the web are there too. A line above the list names the view and what it filters and sorts by, then says how many contacts match, with the view's calculations, like "12 contacts · Sum of Check size $18.3M": pick the calculations on the web. More contacts load as you scroll.

Ask the AI

Ask AI can find contacts with the same filters, like "investors I have not contacted in the last month", and list a type by stage. It can also save the result as a view ("save that as a view called Going cold"), with and / or and condition groups, rename, share or change a view, make a folder of views and put views in it or take them out, and delete one once you say yes. Ask it for a figure, like "the total check size of my seed investors", and it works it out over every contact that matches.

Did this answer your question?

Related

What the CRM is forEdit the CRM table like a spreadsheetMove a contact to the next stage