Is there a way to automate sorting rows by date?
We have several sheets that require users to update the Next Review Date a year out. Then we have to manually sort so that the tasks are in ascending order. Is there a way to automate this currently? Or some sort of work around that I can use?
Answers
-
People have been submitting Enhancement Requests for a way to auto-sort a sheet for ages. My recommendation is to do it as well. The more people that do that the bigger chance they'll finally do it but I've been seeing discussions that go back quite a while on that topic.
As a work around, you'll have to create a report with a Sort for that.
-
Hi @L Graham
This can be fully automated with Webhook and API. So whenever a user adds a data to a certain column it will be automatically sorted.
If you're interested you can email me at info@smartsheetdev.io
-
I'd like a way to automatically sort data rows too.......I have a form that adds rows and then i need to go in and do a manual alphabetical sort. Seems there should be a way.
-
Hello. I would also like to use this functionality. Description of new functionality to add:
- User adds new row to a sheet via a form
- Automation triggers based on new row entry
- Sort operation is run on a whichever column is specified
-
Hi everyone, I've seen dozens of threads over the past 8+ years asking for this feature. So I built a browser extension (SSFeatures) that solves this problem.
SSFeatures adds this "Sort Automatically" checkbox into Smartsheet. You can use this to enable automatic sorting whenever your data changes.
I hope this helps!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com)
SSFeatures - The browser extension that adds essential features into Smartsheet.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives