Calednar date dependant dropdown

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?

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

1 Like

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

Try:

SORT(slice name[start_date], TRUE)

See also:

1 Like

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

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

1 Like