IS there a way to sort/filter rows from Newest to Oldest?
Hello everyone,
I am trying to create a filter where it puts the rows from Newest to Oldest. For some context, we use this Smartsheet log to capture customer requests and this log has requests from 2022 (being at the top) until now (we're in 2024, being at the bottom). We're always having to scroll all the way down to the sheet and it has over 1900+ rows now. It would be nice to avoid this if there is a capability to do so.
Let me know if you need me to include the columns in the Smartsheet for a function or code. But, I am just looking for a way to sort from newest to oldest request. Newest being at the top rather than the bottom. I tried myself but I couldn't find a way. Also, SS has the "sort rows" option grayed out.
Is this possible?
Thank you in advance.
Best Answer
-
Hi @Syllica -- that's actually an enhancement that's on the roadmap. I have some custom code to do this via the API, but you can't do this with native tools yet.
Answers
-
Hi @Syllica -- that's actually an enhancement that's on the roadmap. I have some custom code to do this via the API, but you can't do this with native tools yet.
-
Thank you Lucas for your quick reply. Good to hear this is being considered in the future. It'll be helpful.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!