Generate list of recently updated sheets

Ezra

I would like to have a quick readout of the five or ten most recently updated sheets from WorkspaceA or WorkspaceA --> Folder5

I can build a report that grabs all of the sheet rows by updated in the last 30 or 60 or 3000 days, but how can you get a list like:

1. FinanceSheetXYZ updated Yesterday by John Smith
2. ImpactSheetABC updated 2 Days ago by Beth Roberts
3. ....
4. ...

 

Paul Newcome

The only thing I can think of right off would be some sort of helper column (checkbox?). Use a formula that will flag whatever row is the most recently updated on the sheet. Add in the Modified By and Modified (Date) columns.

Once you set that up on all of your sheets, you can then run a report based on that box being checked.

 

Of course this means adding on to every single sheet in the space/folder and the report won't just grab the top 5, but it will grab the most recent row from each sheet.

 

You can specify which columns (Sheet Name, Modified By, Modified (Date)) and sort by Modified (Date) in Descending Order. That will put your most recently update sheet on top, and the only columns on the report would be exactly what you mentioned above.

 

I know this requires a lot of setup if you already have a lot of sheet and requires that you remember to add this to every new sheet and does not condense it to just the top n, but it's the closest to what you are looking for that I can think of without using a 3rd party app.

Andrée Starå

Hi,

To add to Paul's suggestion.

A possible workaround could be to use a third-party tool like Zapier or similar.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting