Why won't my custom sort list work

New Contributor

Why won't custom data sort accept this list:

Greater than $9,999,999
$5,000,000 - $9,999,999
$3,000,000 - $4,999,999
$2,000,000 - $2,999,999
$1,000,000 - $1,999,999
$500,000 - $999,999
$250,000 - $499,999
$100,000 - $249,999
$50,000 - $99,999
$1 - $49,999

I have tried typing it in several ways and even did the 'import list from cells' which did not work.

3 Replies
I don't know what custom sort list you are referring to and why it wouldn't work. But I would expect that it will sort based on TEXT value so if you mean that the sort comes out in 'crazy' looking order then yes that makes sense because $1 ... comes before $2.... regardless if that is $2,000,000 or $250,000


It is my understanding that the whole point of a custom list is to work around those limitations. I can do it easily if I want the order to be non-alphabetical (Sign, Preprint, Remove). Should not this list follow the same logic? I am putting it in this specific order, therefore, it should sort in this order. Thoughts?

OK so I played around with custom lists (I custom sorting and custom lists...).
I believe the problem is the commas in the text. I was able to make it work if the list of text doesn't have commas. i.e. $2000000 instead of $2,000,000
hope that helps

EDIT:  BTW you can use other characters instead.  So for example I replaced all the "," with CHAR(130) which looks identical to "," but is obviously a different ascii character and could use the custom sort:


but of course you then have an issue trying to type that in.

ALSO please note that sorting of a custom list will ONLY apply to items that exactly MATCH that list so values 'inside those ranges' will not match items in the custom list and will NOT sort based on that custom sort list.