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?
Solved! Go to Solution.
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
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:
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]))
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |