Loading

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

Julkaisupäivä: Apr 3, 2026
Kuvaus

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.

Ratkaisu


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'.
Knowledge-artikkelin numero

000384811

 
Ladataan
Salesforce Help | Article