Dropdown list column sorting

Laurie Mason

I'm working with a sheet that has an unrestricted dropdown list column that the sheet is sorted by. I've found that the column is sorted alphabetically first by the values that are in the dropdown list and then it starts over alphabetically with the values that are not added into the dropdown list. We don't want to add all values to the dropdown, just the most common ones. That is why we have left it unrestricted. Is this as expected? Is there any other way to get a comprehensive alphabetical sort without added all values to the dropdown list?

jmyzk_cloudsmart_jp

Hi @Laurie Mason

Here is a way to get an alphabetical sort without adding all the values to the drop-down list.

1. Create another column and make its value the value in the drop-down list with the column formula.
2. Sort by that other column.

https://app.smartsheet.com/b/publish?EQBCT=437add175b504c3fa8be0113e8936c73

jmyzk_cloudsmart_jp

Hi @Laurie Mason

Here is a way to get an alphabetical sort without adding all the values to the drop-down list.

1. Create another column and make its value the value in the drop-down list with the column formula.
2. Sort by that other column.

https://app.smartsheet.com/b/publish?EQBCT=437add175b504c3fa8be0113e8936c73

Laurie Mason

@jmyzk_cloudsmart_jp Thank you!