How to Sort Picklist (Multi-Select) Values into Alphabetical Order in Salesforce

In this Salesforce tutorial, we will learn How to Sort Picklist (Multi-Select) Values into Alphabetical Order in Salesforce. We will discuss sorting or arranging the Picklist (Multi-Select) Values in Salesforce Lightning and Salesforce Classic.

In Salesforce development we custom create Fields for Objects and items. One such field is Picklist (Multi-Select), we pass values in the Picklist (Multi-Select), and if we have a large number of values, it is very difficult to go through them if not arranged in a particular order. Salesforce provides functionality where we can arrange or sort these values in alphabetical order.

Sort Picklist (Multi-Select) Values into Alphabetical Order in Salesforce Lightning

To Sort Picklist (Multi-Select) Values into Alphabetical Order in Salesforce Lightning login to your Salesforce account and follow the below steps.

Step:1- On the Setup page of Salesforce Lightning, click on the Object Manager tab.

Sort Salesforce Multi select Picklist values
Sort Salesforce Multi-select Picklist values

Step:2- In the Object Manager Select the Object from the list in which you have created a Picklist (Multi-Select). In this case, I have Picklist (Multi-Select) in the Business Brand object.

Salesforce Lightning sort Picklist Multi Select Values
Salesforce Lightning sort Picklist Multi Select Values

Step:3- In this window, we can see Fields and Relationships in the sidebar Details. Now click on Fields & Relationships.

Picklist Multi Select order in Salesforce
Picklist Multi Select order in Salesforce

Step:4- In Fields and Relationships, there will be a list of fields under the Field Label. From here select the Picklist (Multi-Select) field. In this case, I have selected Clients’ Cities to sort the Picklist (Multi-Select) values.

Picklist Multi Select Salesforce order values
Picklist Multi Select Salesforce order values

Step:5- In this step, go to the Values section where you will see the list of Picklist (Multi-Select) values. Now to sort them in alphabetical order click on the Reorder button.

Salesforce sort Picklist multi select values
Salesforce sort Picklist multi-select values

Step:6- Under the section Sort Picklist Values click on the checkbox Display values alphabetically, not in the order entered, and then click on the Save button.

Order Picklist Multi select values in Salesforce
Order Picklist Multi-select values in Salesforce

After clicking on Save, we can see that the Picklist (Multi-Select) values are arranged in alphabetical order as shown in the below picture.

Sorted Picklist Multi Select values in Salesforce
Sorted Picklist Multi Select values in Salesforce

Now we have successfully sorted the values of the Picklist (Multi-Select) field in Salesforce Lightning.

Read: How to Rearrange the Picklist (Multi-Select) Values in Salesforce

Sort Picklist (Multi-Select) Values into Alphabetical Order in Salesforce Classic

To Sort Picklist (Multi-Select) Values into Alphabetical Order in Salesforce Classic, login to your Salesforce account and follow the below steps.

Step:1- After logging in to Salesforce, if you are in Salesforce Lightning mode then to switch to classic mode click on the Profile picture, and in the dropdown click on Switch to Salesforce Classic as shown in the below picture.

Sort Salesforce Classic Multi Select Picklist
Sort Salesforce Classic Multi Select Picklist

Step:2- In this step, click on the Setup tab.

Setup Salesforce Classic Picklist (multi select)

Step:3- In the Setup window, go to the Build section and there click on Customize. Now select the Object in which you have already an existing Picklist(Multi-Select) field. In this case, I will select the object Opportunities. Click on the object dropdown and then click on Fields.

Picklist Multi Select Values in Salesforce Classic
Picklist Multi-Select Values in Salesforce Classic

Step:4- In this step, go to the Opportunity Custom Fields & Relationships, and from there select the Picklist (Multi-Select) field. I have selected the Picklist (Multi-Select) field New Leads.

Salesforce classic sort values of Picklist Multi select
Salesforce classic sort values of Picklist Multi-select

Step:5- After selecting the Picklist (Multi-Select) field New Leads, go to the Values section and then click on Reorder button as shown in the below picture.

Classic sorting Picklist Multi Select Values
Classic sorting Picklist Multi Select Values

Step:6- In this window Sort Picklist Values Click on the Checkbox with the text Display values alphabetically, not in the order entered, and then click on the save button.

Picklist values sorted in Salesforce Classic
Picklist values sorted in Salesforce Classic

Now we have successfully sorted the Picklist (Multi-Select) values in alphabetical order in the Salesforce Classic.

Conclusion

In this Salesforce tutorial, we have learned how to sort or arrange values of Picklist (Multi-Select) in alphabetical order in Salesforce Lightning and in Salesforce Classic.

You may like to read: