Dropdown selector: Sort ref column using a second column.

[shimodabt]

Hi, I am trying to sort values shown in a drop-down selector that contains ref values (ID Helix Prix). I want to sort these values using another column in the ref table (Tri). 

When writing the ORDERBY function and selecting the proposed values by the editor when I start typing, I end up with an invalid code! 

Any clue would be appreciated. 

[Joseph_Seddik · Accepted solution]

ORDERBY() requires key values, so your expression should be:

ORDERBY(A HELIX[ID Helix], [Tri])

[shimodabt]

Thanks, Joseph for taking the time! 

[Joseph_Seddik]

Je t'en prie, bon courage !