So I have cascading dropdowns setup, and the column I want to lookup to is a single line of text field, but it’s causing sorting to be off.
It’s a mixture of numbers and a description, and in the dropdown will look like this:
103 – WCN_CA_NBO_TUST_WB
1030 – GBNC RES_HN
1034 – GBNC Managers
1035 – MTLA RES_HN INACTIVE
105 – LS Alt Ch ESC Team
I have another column that takes the numbers you see, and holds them as numbers so that I can sort in true numerical order.
My question is, how can I get the lookup to go to the column with the numbers and description, but sort them in the dropdown by the numerical value column so they stay in proper order?