Automated Sort in Sheet

Christina England

Is it possible to create an automation that sorts the rows automatically when changes are saved?

For example, if my sheet is sorted by Column "Stage" Numerically Increasing, and I insert a row, fill it in, and save it, I want the sheet to re-sort to incorporate that added row in its proper location.

Thank you!

Paul Newcome

There is no way to do this within a Sheet. You can however use a report which does auto-sort and a form to add new rows with both placed on a dashboard.

Paul Newcome

There is no way to do this within a Sheet. You can however use a report which does auto-sort and a form to add new rows with both placed on a dashboard.

SSFeatures

Hi @Christina England, I noticed a lot people asking for this same feature, so I built a browser extension (SSFeatures) to solve this.

With SSFeatures, you'll notice this "Sort Automatically" button in Smartsheet. Then when you click it, all of your data will sort automatically.

Best!