Is it possible to automate a work flow that sorts rows by date when a sheet changes?
I have a sheet that I pull reports from into a dashboard. it would be great if the most recent rows sat at the top of the sheet. Currently I have to manually sort the date column.
Answers
-
2 ways to handle this
- an API script that does this whenever rows are added.
- use the SSFeatures browser extension to do this when you open the sheet. Here's a demo of that.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
Thanks Darren! That is an awesome feature…I'm not sure that I will get funding for your tool though. I'll certainly follow your channel on YouTube.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 40 Webinars
- 7.3K Forum Archives