Skip to main content

Sort & group views

Order the records of a view by one or more fields, and group them by a field such as status, member, or date.

Written by Leo

Sorting puts the records of a view in order, such as the newest first. Grouping collects records under a shared value, such as all tasks with the same status. Both are meant to help you read a long list of records at a glance.

A table view with the Sort menu open and the records sorted by Property type

Note:

  • The board is always grouped. Its columns are the groups. The board toolbar has Group instead of Sort.

  • Changes stay unsaved until you save the view. Learn more about saving views →

  • Groups need a suitable field. Not every field type can be used to group a view.

Who can sort and group views?

  • Sorting and grouping are available on all plans: Free, Plus, and Premium.

  • Everyone who can open a view can sort it for themselves. Groups are set in the view's settings, so to group a team view you need Full access or Can share. In your private views you can always group. Learn more about creating and managing views →

Sort a view

  1. Open a table or list view and click the sort icon in the toolbar (its tooltip reads Sort). A list of fields opens.

  2. Choose a field. Type under Search for a field… to find it.

  3. Choose Ascending or Descending.

Selecting Sort, choosing Property type, and opening the direction with Ascending and Descending

A view sorts by one field. To remove the sort, click the icon with the tooltip Clear sort on the Sort button.

Group a view

  1. Point at the view in the view list and click ••• (its tooltip reads Settings).

  2. Select Group by.

  3. Choose a field.

Opening the settings of a view, selecting Group by, and pointing at Investment stage

None removes the grouping. You can group by these fields:

  • Single select and Multiple select

  • Status

  • Member fields

  • Relation fields

  • Date, Created on, and Last edited on

  • Calculation fields that return a date

Group dates by a period

When you group by a date, a row called Date by appears. Choose how dates are put together: Day, Week, Day of week, Month, or Year.

Order the groups

Once a view is grouped, the settings show more rows:

  • Sort: choose what the groups are ordered by (Sort by) and the direction (Order). You can order by the group itself (for example Option, Name, or Date, depending on the field) or by Count, the number of records in it.

  • Group limit: choose how many groups to show, for example 5 groups, 10 groups, 25 groups, 50 groups, or 100 groups.

The settings of a grouped view with Group by, Sort, Group limit, and Status bar

Group a board

On a board, columns are groups. Click the group icon in the toolbar (its tooltip reads Group):

  • Group by: choose the field that makes the columns. A board can be grouped by a Single select or Status field.

  • Color columns: colors the columns.

  • Under Groups, you see every group of the field. Drag a group to change the order of the columns.

The Group menu of a board with Group by, Color columns, and the groups

FAQs

Can I sort a view by more than one field?

No. A view sorts by one field at a time. To bring records with the same value together, add a group as well.

Can I group by a Number or Single line text field?

No. Groups work with select, status, member, relation, and date fields.

Why is there no Sort button on a board?

The board toolbar has Filter, Search, Group, and Customize. Use Group to decide how the columns are arranged.

Can I group a view by two fields?

No. A view can be grouped by one field at a time.

Where can I find an overview of views?

In Views, filters, sorts & groups →. It explains Table, Board, and List layouts, team and private views, and how filters, sorts, and groups fit in.

Still have more questions? Find answers and get help from community experts in the Tape community →.

Did this answer your question?