Loading

Sort by Ascending or Descending for picklist field in a related list

Date de publication: Apr 3, 2026
Description

If the value you are sorting by in the related list is a picklist, why isn't it sorting it alphabetically?

The section is on the page layout editor, choose the related list, see the sorting order of the records in the related list. If it is being sorted by a picklist value, it may not show alphabetically. Why?

For example, an admin notices that opportunities on an Account related list sorted by Stage appear in the order 'Closed Won, Prospecting, Needs Analysis' rather than alphabetically. This is because sorting follows picklist value order, not alphabetical order.

Résolution


The reason for this is that it is sorting by 'Ascending', not alphabetically.

So, if the picklist values are ordered as:

b
c
a

... then they will order 'ascending' according to that order.

To resolve this, you order the values of the picklist alphabetically.

Warning: A field may have the order of the picklist values set according to a business reason or process. For example, Status - Open, In Progress, Closed. Alphabetically, these would be in the order: Closed, In Progress, Open - which does not make sense logically for a process.
 

  1. Go to the affected picklist field within Setup.
  2. Click on the field name and click Reorder.
  3. Select Sort values alphabetically, not in the order entered. Values will be displayed alphabetically everywhere
  4. Click 'Save'.
Numéro d’article de la base de connaissances

000384811

 
Chargement
Salesforce Help | Article