Auto Sort

Sean Taber · 03/05/20

Hello,

Is there any way to create automation that will automatically sort a sheet when a cell is updated or changed?

Thank you,

Sean

Mike Wilday · 03/05/20

Have you considered using a report? A report can gather all of the data in your original sheet and display it (keeping it editable in the report) in a sorted order. The only challenge with a report is that if you are using hierarchy (indented rows) the report does not keep hierarchy. Perhaps that will work for you.

Mike Wilday · 03/05/20

Have you considered using a report? A report can gather all of the data in your original sheet and display it (keeping it editable in the report) in a sorted order. The only challenge with a report is that if you are using hierarchy (indented rows) the report does not keep hierarchy. Perhaps that will work for you.

Sean Taber · 03/05/20

Thank you, after I posted I searched and saw this question has been asked a good amount. I will give the report a try.

Sean

Mike Wilday · 03/05/20

Sounds good! If it works out for you please mark my answer as best answer.

latheobald89201 · 09/17/21

I would like to request this as an automation update. Yes we understand reports. We would also like this option in the mainsheet as well.

SSFeatures · 02/12/25

Hi @latheobald89201, I created a browser extension (SSFeatures) that lets you automatically sort your data in the main sheet.

The extension adds a "Sort Automatically" button that you can enable to automatically sort your data.

Best!

Smartsheet Basics

Smartsheet Basics

Auto Sort

Best Answer

Answers

Quick Links

Categories

Trending in Smartsheet Basics

Has anyone tried to create a trivia game using Smartsheet?

What's the maximum number of rows in a sheet ? Is there any limitation on the number of columns ?

Sharing Permission; Shared Sheet Management for Unlicensed User/Free Collaborator