List Views: Sort By Multiple Columns in Salesforce | Scribe

    List Views: Sort By Multiple Columns in Salesforce

    • SalesforceSalesforce
    alert ordinal icon
    Sorting List Views by Multiple Columns will be Generally Available following the Salesforce Spring '25 release but you can ask your Admin to activate it now by following [this guide](https://scribehow.com/shared/List_Views_Enable_Sorting_by_Multiple_Columns_in_Salesforce_Admins_only__NzC323JTS0eH5vrOdQKGuQ?referrer=workspace). Otherwise, you have to wait for it to roll out to your Org sometime from February 2025 onwards
    information ordinal icon
    Pro Tip: The demo below uses Opportunities, but it applies to any Salesforce List View - including custom objects

    Scenario

    1
    It's a new week, and you're preparing for the internal sales meeting to discuss how deals are progressing. To give you the clearest picture of those most likely to land with the largest value, you want to order your Opportunities by Most-to-Least **Probability (%)**, then by **Stage**, in alphabetical order and finally by Most-to- Least **Expected Revenue**

    Sorting by Multiple Columns

    2
    From your List View, click the Column Sort icon top right
    3
    Select the first field you want to sort your data by, In our scenario, its: "Probability (%)"
    4
    In our scenario, we want to go from highest to lowest Probability, so select "Descending"
    5
    Next, select your next field - so we select "Stage" And we'll leave it in alphabetical order, so we'll leave "Ascending" checked
    6
    We want to sort by another field, so click "Add a sort column"
    7
    And in our scenario we'll select "Expected Revenue" for this one
    8
    And we also want this from highest to lowest, we'll select "Descending"
    9
    You can add up to 5 different columns if needed. In our scenario, we just have three, so we can click "Apply"
    10
    You'll see that your data is now ordered first by Probability, then by Stage, and finally by Expected Revenue You're ready for your Sales meeting!
    11
    Your Column Sorting is saved until you remove it. So if you revisit a List View where you have already applied Column Sorting it will still be there. You can easily see the criteria used at the top left of the List View.

    Refine your Ordering for a different picture

    12
    If its not quite the result you wanted, you can change the priority of the Columns. Click on the "Column Sort" icon again
    13
    Use the "Sort by" arrows to re-order the columns and then click "Apply" again. You'll see the new configuration applied. In our example, "Stage" will now be the second column to be sorted and "Expected Revenue" the final one.

    Reorder on the List View

    14
    If you want to Reorder the data within a Column, for example from Lowest to Highest, you can just click the Column Heading. For example clicking here on the "Probability" Column Heading will bring the lowest Probability to the top. The other sorted columns will still apply.