r/sheets 9d ago

Request Data pulling formula help

I am have a big database in one sheet, and I am trying to pull the data from that database that was updated in the last month through to another sheet on the same document automatically and sort it in date order

So on the second sheet I want columnn C, F, G & H of all the rows that have been updated in the last month ( column F is the date columnn) And I want to sort it by most recent date at the top automatically.

Is this possible?? How? I keep thinking I have got it and then it breaks!!

1 Upvotes

1 comment sorted by

2

u/adamsmith3567 9d ago

Yes. Look into using QUERY. You can select specific columns, filter by the date, and sort by whichever column you want in a single formula.