Sort a list

You can quickly find information in a list by sorting the list. The method that the system uses to sort a list depends on the type of record in the sort column.

Before you begin

Role required: none

About this task

Consider the example record: Label=Requested Item; Value=sc_req_item. Field types other than choice list types are sorted based on the label. The example record label, Requested Item, would be sorted with records whose labels start with "r."

A choice list field lets the user select from a pre-defined set of choices. Choice list fields are sorted by the underlying dictionary entry value of the field, not by the label. The example record value, sc_req_item would be sorted with records whose values start with "s."

Sorting by value can be useful. For example, choices for the State of tasks are ordered New > Work in Progress > Closed. Based on the label, the sort would be Closed > New > Work in Progress.

An arrow next to the column name indicates the current sort order. A downward pointing arrow indicates that the column is sorted in descending order. Only the primary sort order is indicated.
Note: The following sorting rules apply to lists:
  • In a translated instance, only translated_text, translated_field, and translated_html type columns support sorting.
  • The column label should be created in English first then translated accordingly.
  • You cannot sort a list by an array-based field, such as a Glide list.

To sort a list, use one of the following methods:

Procedure

  • Click a column name to sort the list in ascending order. Click again to sort in reverse order.
  • Right-click a column name and select Sort (a to z) or Sort (z to a) to sort in ascending or descending order, respectively.
  • Specify a sort order with a filter. Filters provide for sorting by more than one column (for example, by Category and then Subcategory).