Dropdown Columns via a Lookup - How to change the order?


Currently by default if you create a drop-down column based on another table via ‘Lookup From Table’, the drop-down menu is in order of Row ID (essentially order of creation). Is there a way to change this? Simply changing the sort mode of the original table has no effect. In most scenarios you want the drop-down to be alphabetical for easy searching.


Adding a sort option to Lookup would be great. Will add this to our feedback tracker!
You can workaroud this by using Select list and using Sort() in the formula there but this is different from a lookup (where you get @refs in your column)


I am wondering, if there is an option to lookup in the list in Table 6, sort the list in Table 7 and at the same time have the option to enter new item to the list by typing it in Table 7.Column 2?