SharePoint 2013 LIst Filters (by latest date)
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.