Auto sort Rows

Jon Barto

is there a way to auto sort rows based on a column. I have one column with drop down and want the rows to all sort based on the order of the drop down. If I add a row or change that dropdown in column I want the rows to auto sort.

Right now I have to right click the column every time to sort when data is changed

Paul Newcome

There is no auto-sorting feature in sheets. This is only in reports at the moment. I believe that the idea has already been submitted as an enhancement request. Feel free to browse the Product Ideas tab at the top of this page and add your vote.

Jon Barto

Ok thanks Paul. I will defiantly vote for that feature

Melinda_eMS

There's no way to automate it using when rows added as a trigger? I'd love to do this so my High priorites are always at the top of the sheet

KPH

Not within a sheet. You can do it in reports but not sheets.

Paul Newcome

@Melinda_eMS You would need to leverage the API to get it to auto-sort within a sheet. Otherwise you would want to use a report.

https://help.smartsheet.com/learning-track/smartsheet-intermediate/reports

malorie

Does anyone know an update on this topic? I'm interested to know if there have been any developments in this area??

KPH

Hi @malorie

The enhancement is on the long-term road map, you can follow it, and add your use case, here:

https://community.smartsheet.com/discussion/103157/automatically-sort-rows-in-sheets