Sorting is another way to customize your view to your particular needs. With sorts, you can rearrange your rows to prioritize certain information in either Kanban or Sheet views, as sorts operate similarly in both view types.
Sorts can be a good way to change the order of data in a sheet. For instance, if you're the HR manager of a team and you want to sort candidates by their interview score, you can sort by rating. In the animation below, we can do just that, choosing to see top-rated candidates first. Then we add another sort on top of it our rating sort
To create a sort, select the sort button and click New sort. Choose a column from your existing columns to sort, and then select either of the sort order buttons.
Sort options change based on the column's data type. For instance, you can sort a column of a number type down from 1 to 9 or up from 9 to 1 . Or you can sort users alphabetically from A to Z , or Z to A .
To remove a sort, select the delete button next to the sort you wished removed.
Sorts can be reordered to focus on a different column. To reorder a sort, click on the sort button , navigate to the sort you'd like to move, select the desired sort by clicking the drag handle , and drag the sort into the desired order.
Each additional sort acts as a sub-sort, sorting rows within the initial sort groups. For instance, in our example above candidates are sorted first by rating, then years of experience—resulting in all 5-star candidates going to the top, then candidates who are at five stars being sorted by years of experience from most to least.
As is typical with spreadsheets, columns do not automatically resort when you add, delete, or change data. To refresh the view, reapply the sort and your columns will account for the change.