Sort records in a view
Add up to 5 sort keys, applied in order. Select and status fields sort by the order of their options, not alphabetically.
Steps
1
Open the view and choose Sort.
2
Press Add sort, choose a field, and choose Ascending or Descending.
3
Press Add another sort to sort records that have equal values.
4
Save the view.
How it works
Type
How it’s sorted
Select, status, priority, source
By the order of the options in the field’s settings, with empty values always last
Currency
By amount
Number
An empty value counts as the smallest
System fields
Created At and Updated At
Ordering cards by hand in the Kanban only works if the view has no sort. See Use the Kanban board: grouping, dragging and cards.
If something goes wrong
What you see
Why
What to do
“Can’t sort by relation ‘…’.”
You chose a relation that links several records.
Sort by a rollup field on it instead.
“Field ‘…’ can’t be sorted.”
The field has no stored value.
Choose another field.
A real example
Basma Clinics
The situation
The appointments list is all mixed up.
What they did
- They sorted by priority, then by appointment date, ascending.
The result
Urgent cases are at the top, followed by the nearest appointments.
A made-up company, to show the idea. The numbers are rounded.
Good to know
Up to 5 sort keys.
You can’t sort by a relation that links several records, or by a computed field with no stored value.
The same field can’t be used twice in the sort.
Infinite scrolling in some lists shows the newest first only.
Did this guide solve it?
If not, we’ll ask what was missing.