Sorting Data

When you create a new sheet and add data, you can sort your rows so that they appear in a specific order according to the values in columns. Sorting your rows applies to the sheet you are currently using

To apply a sort to your table, click the sort button in the toolbar. This will bring up the sort dropdown menu. If your table has any sorts already applied, then these will appear in the dropdown. If there are no sorted fields, you will see "No sorting applied" message. To sort by a column, click the Pick another field to sort by and then select a field from the dropdown menu. Then you will be able to choose whether to sort ascending or descending. When you are ready with your choice, click the Apply button to apply the sorting.

You can add more sorts by picking more columns to sort by from the dropdown menu. You can remove any of the sorts you've applied by clicking the X button next to a sort, or reorder the sorts by using the drag handles.

  • String columns can be sorted in alphabetical (A → Z) or reverse alphabetical order (Z → A). 
  • Numerical columns, can be sorted in ascending numerical order (1 → 9) or descending numerical order (9 → 1).
  • Date/time columns can use ascending order (1 → 9), which is from the earliest date to the latest date, or descending order (9 → 1), which is from the latest date to the earliest date.

You can notice the Maintain sort option. If this toggle is turned on, rows will automatically sort themselves if a change occurs to a row that would cause it to be ordered differently according to the applied sort order. Otherwise, when the toggle is turned off, sorting will be applied just once.