Feb 27 2020 11:53 AM
I am trying to sort a list by the latest date before a predefined date. I need it to also sort on 2 other columns. Basically I need the last date entered before [Date] for each drop down choice
Drop down
Column 2
Date
End Date - (latest record after a date)
I found a few things online but I'm not sure where I would add this or what the best plan of attack would be.
Filter(ListName,Date=First(Sort(Distinct(ListName,Date),Result,Descending)).Result)
Any help or direction is greatly appreciated.