Automated Sort in Sheet

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!

Find more posts tagged with

Sheets

Support

functionality

Automations

Accepted answers

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.

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.