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.
