Forum Discussion
Why won't my custom sort list work
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.