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.
so right now i have the valid if statement
what would it be just to order these dates in descending order
SORT(slice name[start_date], TRUE)
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]))