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.

I’m facing exactly the same issue.

I’m using ARRAYJOIN(values) and they are organized exactly in the mirror order as @Claire_McKeever described. any solutions? lookup from lookup didn’t help!

Sorry my explanation was not very good. have a look at the screenshot attached and you will understand how it works. Lo siento amigo.

If you create a field with Rollup and Arrayjoin (values) it will be sorted in the correct order. The order it was added.