Is there a way to automate sorting rows by date?

L Graham

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?

Mike TV

@L Graham

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.

smartsheetdev.io

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

Robert Schulingkamp

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.

Geoff Grove

Hello. I would also like to use this functionality. Description of new functionality to add:

1. User adds new row to a sheet via a form
2. Automation triggers based on new row entry
3. Sort operation is run on a whichever column is specified