How i show a drop-down values in alphabetical order of label

[Ramos_Ramos]

I need show a drop-down in alphabetical order of a label, but is apresented in order of rowline_

[mrowan1]

How are you populating your list?  If using something like:  Customers[Name] where Customers is the table, and [Name] is the column being returned, then you should be able to use either of the following:

SORT(Customers[Name], TRUE) - TRUE = sort descending
SORT(Customers[Name], FALSE) - FALSE = sort ascending

or

ORDERBY(Customers[Name], [Name])

With ORDERBY, you can sort on a column other than the one being returned, eg ORDERBY(Customers[Name], [City])

[Ramos_Ramos]

My dropdown is populated by a ref column

[SkrOYC · Accepted solution]

If you are using Ref to TableA, use this on the Valid_If field of that column:

ORDERBY(
 TableA[KeyColumn],
 [LabelColumn],
 true # descending, false for ascending
)

ORDERBY() - AppSheet Help

[Steve]

Drop-down from Valid_If - AppSheet Help

[Laurie_Nason]

OK - I am still trying to work this out. 

I have a tab in google sheets which has a whole bunch of columns that are validation values for various other columns - I want to select a column e.g. Validations[Benchmark] - but have it display in the order that they have been entered in the sheet - e.g. sorted by rownumber

No matter how I try - I cannot get them to return the list in the order they are entered - it's not alphabetical and I don't want to store a key value (it's the row number anyhow) - in SQL I would do the following:

SELECT Benchmark from Validations WHERE Benchmark is not null ORDER BY _rownumber

[Steve]

Please start a new topic for help with this.