I have two enum variables set in User Settings - first State and then City - which work perfectly in terms of displaying unique states and then related cities to the selected State - except that the displayed lists are not sorted. Iโve set the valid if for state (and done similarly for city) as TOOL4FORAPPSHEET[State] (where TOOL4FORAPPSHEET is the table). I canโt seem to get any other function to work properly (e.g. orderby, filter or select). Guidance would be really appreciated. Thanks.
LinkedIn
Twitter
