Main Help Page

Sorting

You can sort the items in a Delectus list by clicking the label of a column. You may have noticed this already if you clicked a column label for some other reason, such as to delete or rename a column.

How does Delectus sort the list? When you click a column for the first time, Delectus sorts all of the items in the list according to the column you clicked. It sorts the items in ascending order—usually, that means it sorts in alphabetical order.

The second time you click the same column label, Delectus sorts by the same column, but in reverse order.

The third time you click the same column, Delectus puts the list back the way it started, unsorted. An unsorted Delectus list shows its items in the order you created them.

If you click a different column at any time, Delectus sorts by that column instead. It always follows the same order listed above: first it sorts forward; then it sorts in reverse; then it removes the sort.

Sorting by Number

What if you have a column that you want to sort by number? You may have noticed that programs that sort things alphabetically produce results you may not like with numbers. For example, they usually sort "1, 2, 3, 11, 220" as "1, 11, 2, 220, 3", which is generally not what you want.

Delectus automatically detects when all the items in a column are numbers, and it sorts them numerically, instead of alphabetically. This feature works only when every item in a column is a number. If you enter something that isn't a number (or some non-numeric text in addition to a number), then Delectus goes back to sorting it alphabetically.