Generate list of recently updated sheets
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:
- FinanceSheetXYZ updated Yesterday by John Smith
- ImpactSheetABC updated 2 Days ago by Beth Roberts
- ....
- ...
Comments
-
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.
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!