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
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!