Forum Discussion
SORTBY Formula
Hi, I'm looking to add a SORTBY function to an existing FILTER formula. The current formula I have to drag the below information from the main table is the following; =FILTER(Table2[#All],T...
I'd use a separate row to return the headers:
=Table2[#Headers]
In the cell below the cell with that formula:
=SORT(FILTER(Table2,Table2[Tender Completed?]="No",), 4)