How do I sort a column alphabetically when some inputs are in all caps?

bgarrigan

SmartSheets seems to be ignoring the text entries that are all caps when sorting a column. Looking for a solution since some of my entries are acronyms and some are not.

Paul Newcome

Are you able to provide a screenshot of what is happening and then a second screenshot with the data manually entered to reflect what you want to happen?

bgarrigan

Turns out it wasn't the ALL CAPS that was messing with the sort, it was the ordered list from the drop down I created. Do I have to manually alphabetize the list or is there something that will ignore that order and sort automatically?

Andrée Starå

Hi,

Where do you want to show the information?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Alejandra

Hi @bgarrigan,

If you sort on a column that is a Dropdown List type, items will be sorted using the order of the drop-down list values. More information on this can be found here under "How Different Data Types Are Stored".

https://help.smartsheet.com/articles/504742-sorting-rows