Suggested values misordered in the form

[Msidacappu]

Hi, 

I set one column in "valid if" and the items are pre-typed in one spreadsheet. And another column is set in "suggested values" and its items are list next to previous list (items of "valid if)". 

In this way, when I choose the item from "valid if" list, the reference items of "suggested values" will be shown. However, I fond the items in "suggested value" will sometimes become misorderd in the form and I don't know why. 

[TeeSee1]

If your expression uses just a col or select function, then the order of returned list is not guaranteed. You probably want to use SORT if you want the dropdown list sorted all the time.