Sorting Alphabetically

[Data_Team]

Hi all - I have a table in grid view that I’m trying to group and then sort alphabetically.

The table is:

1. Grouped by StateOrProvince from First-Last
2. Sorted by StateOrProvince from first-last

No matter how I group, sort, etc. I can not get the table to group/sort alphabetically by State.

Any insight you can offer is so appreciated. Thanks!

[ScottWorld]

Your screenshot is sorted alphabetically.

[Data_Team]

@ScottWorld ah the screenshot does not accurately capture. All 50 states are in this table and yet not sorted alphabetically. If you could see the whole table you’d see that after AL and AK should be before AZ, etc.

[ScottWorld · Accepted solution]

Single-select fields are sorted in the order in which they appear in the single-select list. Go in to customize your field, and you can click on the “Alphabetize” button. (Or you can manually drag-and-drop the options into the correct order.)

[Data_Team]

@ScottWorld, I see it, thank you!!

[CTerwilliger]

Hello, I have a similar problem, but don't see or have that option. How do I access it.  Not seeing: customize 

[Kaiserin]

Hi I also have the same problem! I have a list  which does not sort alphabetically even when I click on sort A-Z, it seems to stay in the order that I entered it.

Nor can I find the customise button

this is ridiculous for a product that should simplify the management of the information.

The Help service does not seem to engage with my issue when I contact them and just cut and paste lots of videos