Hello
So I have a spreadsheet here with sizes and names of the months. Is there a way to create custom lists for sorting so it would sort them not only by alphabetical order? (i.e. XS-S-M-L-XL-XXL / Jan-Feb-Mar etc.)
Hello @alexkachi, currently there is no way to do it, but we will consider the idea
Hello there.
I don’t think you need a custom list for that. Just add a hidden column and assign numbers to items referencing the order you wish to achieve. If you derive “months” from a date this can be done with “MONTH()”, otherwise use “IFS()”. It’s very easy when you think about it.
Personally I always sort/filter by formula (MATCH() + INDIRECT()). It’s very easy too. The other build-in options just create the illusion of sorting/filtering, by hiding everything that does not hit the filter criteria or rearranging the original order. I don’t like my data to be touched. Sorting/filtering by formula gives you only what you are looking for and is better to process from there on IMHO.
The suggested approach is a great alternative. Also, we have added the request for this feature to our tracking system and will notify as soon as there is news