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.
Note:
The board is always grouped. Its columns are the groups. The board toolbar has
Groupinstead ofSort.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 accessorCan share. In your private views you can always group. Learn more about creating and managing views →
Sort a view
Open a table or list view and click the sort icon in the toolbar (its tooltip reads
Sort). A list of fields opens.Choose a field. Type under
Search for a field…to find it.Choose
AscendingorDescending.
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
Point at the view in the view list and click
•••(its tooltip readsSettings).Select
Group by.Choose a field.
None removes the grouping. You can group by these fields:
Single selectandMultiple selectStatusMemberfieldsRelationfieldsDate,Created on, andLast edited onCalculationfields 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 exampleOption,Name, orDate, depending on the field) or byCount, the number of records in it.Group limit: choose how many groups to show, for example5 groups,10 groups,25 groups,50 groups, or100 groups.
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 aSingle selectorStatusfield.Color columns: colors the columns.Under
Groups, you see every group of the field. Drag a group to change the order of the columns.
FAQs
Can I sort a view by more than one field?
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?
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?
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?
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?
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 →.
