Lookup integer sorting order



I was wondering if there is a way or perhaps if its under development: a way to order lookups of short text fields and number fields the same. As it currently exists it seems that it lists each item from left to right in a text look up, but from right to left in a numerical lookup. See attached image for example.

Any insights are greatly appreciated!


I’ve actually found that it’s even worse than just numerical vs. text. It’s that the linked field and lookup field list in opposite order–that is, if you manually move the records in the linked field, the records in the lookup field changes to mirror that order. I’m not sure why this is and would love either a workaround or a feature fix!


I agree, this should be fixed!


I found a solution. To make things short, add a lookup field from the linked field. You will have 2 lookup fields side by side in the exact same order as it is supposed to be. Good luck.