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...
Or, in one formula:
=VSTACK(Table2[#Headers],SORT(FILTER(Table2,Table2[Tender Completed?]="No",), 4))
HansVogelaar Thanks so much! for some reason its not liking me trying to turn the 'Outstanding Tenders' table into the same formatted table as the 'Tender Register' do you know a way around this?
Unfortunately, you cannot use a dynamic array formula in a table. Such a formula will return a variable number of rows, but a table cannot spontaneously resize itself to accommodate that.
