Automatically Sort Rows in Sheets

James McDow

Would love for auto sort to be a feature on a sheet. I am working on a project now where we put sites in a ranked order based on multiple factors that give us a score, that constantly changes. As the score updates, I have to go in every week and resort the main page. If you would like to speak on this, I would be delighted.

JonB

Just here to add a +1 for auto-sorting. There seems to be a lot of support for this feature. Let's do it team!

Cleversheet

https://community.smartsheet.com/discussion/comment/408748#Comment_408748

@cvvasey Cmd-f (Ctl-f on Windows) enables this.

Sachiko Kagami

This auto sort function would be very helpful and save our time.

meb_0101

Really hoping to see this update soon given it's been on the roadmap for almost a year! It seems minor but I know our company would use it on a lot of sheets. Would definitely help avoiding user error when people inevitably forget to resort rows.

Laurie Mason

https://community.smartsheet.com/discussion/comment/335718#Comment_335718

@marc4 What programming language is this in? I have another script in Python, that is suppose to auto sort the sheet, but I keep getting the error message below:

Error sorting sheet. Status code: 405

"errorCode" : 1122,

"message" : "Requested URL does not support this method: PUT",

MATF12

https://community.smartsheet.com/discussion/comment/422618#Comment_422618

Would have to agree, I would think this would be one of the easier things to implement, especially in anything grid based.

marc4

That is just a linux shell command using the curl program

Katecreates

It is hard to sell this product to our team when Excel does this important shared spreadsheet work better. Please add auto sort based on at least one column.

Kristen Matsushino

Agree this is a basic and CRITICAL functionality. Adding this to an automation would be amazing

Keri Sprinkle

If you're looking for a competitive reason to prioritize this feature ... the LACK of auto-sorting is the reason I have switched back to Airtable for more than half my use cases.

My company has an enterprise license for Smartsheet, and I was a member of our Smartsheet council, but the lack of auto-sorting made it unusable for most of my use cases, which relate to managing tasks and content. For me, the free version of Airtable is more useful than the enterprise version of Smartsheet because of that ONE feature.

It wouldn't have to be as easy as Airtable. I would be fine with creating an automation workflow, but there are NO options to keep a sheet sorted.

dnightingale

Adding another vote for auto-sort. Having to manually update the sort feature every time is so tedious. This is already a feature in Notion and Airtable which makes them both much more user friendly.

dgrant28

Can we please get this heavily requested feature added as a work flow? Trigger: When rows are added or changed → Sort By

Yvonne Jones

Have their been any updates to this function being added? Can Smartsheet provide an update please?

Andrée Starå

https://community.smartsheet.com/discussion/comment/439953#Comment_439953

Hi,

I hope you're well and safe!

Unfortunately, no, but it's still an excellent idea!

Add your vote!

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!