Calednar date dependant dropdown

[Dan_Oliphant]

Hi All, I have a dependant dropdown with dates. in the data, the dates are not in order. is there a way to order the dependant dropdown?

[Steve]

Not in a dependent dropdown. You’ll have to construct a suitable Valid If expression instead.

[Dan_Oliphant]

so right now i have the valid if statement
slice name[start_date]

what would it be just to order these dates in descending order

[Steve · Accepted solution]

Try:

SORT(slice name[start_date], TRUE)

See also:

help.appsheet.com

SORT()

Sorted list items

[Dan_Oliphant]

thanks, but now the next column in the form is not filtering the dropdown. any reason for this?

[Dan_Oliphant]

for whatever reason when you put this in to the next dropdown it works
IN( [_THIS], SELECT(Regions[Country], [_THISROW].[Lead Region] = [Region]))