Sort
Sorting allows the user to reorder rows by the contents of a column. This is a live continuous sort, and new rows that get added or rows that get edited will be resorted immediately after, and you will not be able to manually reorder rows.
You can sort on multiple columns with multiple sort directions.
Known limitations
- If you have an active sort applied to the table, you will not be able to reorder rows since the sort overrides any manual reordering.
Supported column types
TYPE | SORT LOGIC |
---|---|
Text | Sorts alphabetically by text value. ("a", "abs", "apple", "b", "bar") |
Number | Sorts numerically by number value. (-1, 0, 1, 2, 3, 10, 20, 30, 100) |
Date and time | Sorts chronologically by date/time value. (1/1/20, 2/2/20, 2/2/20 4:00 PM) |
Person |
Sorts alphabetically by displayed user name or email. Note: when sorting cells that have multiple selected users, it sorts the list of selected users first. |
Dropdown | Sorts by the order of the dropdown options. |
Tags |
Sorts by the order of the tag options. Note: when sorting cells that have multiple selected tags, the order is determined based on the relative order of the tag options. |
Checkbox | Sorts by checked value. |
Auto ID | Sorts numerically by the AutoID number value. |
Creator | Sorts alphabetically by displayed user name or email. |
Updater | Sorts alphabetically by displayed user name or email. |
Update time | Sorts chronologically by date/time value. |
Create time | Sorts chronologically by date/time value. |
Comment time | Sorts chronologically by date/time value. |
The following column types are not supported for sorting:
- File Attachment
- Location