Automatically Sort Rows in Sheets

As rows get added & cell values change, it would great if we could automatically sort them in the sheets themselves instead of having to set up reports. Adding the ability to do this in a workflow would be a fantastic addition. Right now we have to do it manually.

Sign in to vote!

Find more posts tagged with

Sheets

Available Now!

Workflows in Smartsheet

Comments

Loann McGee

@SSFeatures - according to Chrome this is not a free extension. Did I miss that being mentioned it the above post? If it's not there, I highly recommend that any cost be mentioned for transparency. I've never paid for a Chrome extension, and I don't have budget authority to do so.

Chizu Hieida

Is this gonna be available for Grid view?

Adrian Mandile CHESS

Hi @keats76 and others,

This AutoSort feature is available in a very nifty browser extension I came across called SSFeatures. It has quite a few other goodies included, like:
• Copy & Paste Automation Workflows,
• Conditional Format cloning for multiple columns,
• Copy & Paste Conditional Formatting,
• Grouped Report PDF generation,
• Spell Checker,
• Selective Hide/Unhide columns,
and many more…

Genevieve P.

Hi all,

The status of this specific Idea (Automatically Sort Rows) has been updated to "Available" as Table View features automatic, personalized sorting that updates on load or refresh.

There are a lot of related suggestions in the thread here and we are still actively gathering feedback on sorting. For new feedback, it would be best to track these as individual ideas with their own votes and explanations on how the individual features will benefit you as you work in Table view.

Please create any new Ideas about Sorting in Table view here (with the tag, Sort), or search and vote on one if it already exists!

Thank you,
Genevieve

kowal

Well this problem is resolved in Table View that is available to public now.

Loann McGee

@Adrian Mandile CHESS - I downloaded this auto-sort extension but I would have to buy it after the trial period. Did you find a free version?

Loann McGee

https://community.smartsheet.com/discussion/comment/480003#Comment_480003

Glad it's in Table View, but we cannot yet use that view. Thus, the issue remains for Grid View which being a legacy platform, I'm saddened it wasn't included in the feature. I have to resort various grid sheets multiple times a day which eats away at valuable time.

SteCoxy

https://community.smartsheet.com/discussion/comment/480053#Comment_480053

as a workaround until Table View becomes available for you can you not create a version of the sheets in question by way of a row report, which DO auto-sort them?

SHarris

As suggested by @Genevieve P. , I switched to Table View and found that sorting is available, but only for a single column at a time. I need sorting across multiple columns. This seems like a step backwards, not an improvement. Am I missing something?

Loann McGee

https://community.smartsheet.com/discussion/comment/480095#Comment_480095

Oh! Yes, that would not be of benefit, as our sort from a few of our sheets use the three tier criteria (I wish it had more but we can make do with this). Guess I will remain in Grid View and pray that sort option, though manual, is never minimized.

Loann McGee

https://community.smartsheet.com/discussion/comment/480085#Comment_480085

We do have several reports from these sheets for other purposes, but this is one where rows are added frequently which can't be done on reports.
I appreciate the brainstorming!

SteCoxy

https://community.smartsheet.com/discussion/comment/480123#Comment_480123

yes, you can't add new rows into a report, but that would give you the functionality you need, so the source sheet(s) would be where you can do this and then use the row report for the viewing/number crunching. Create an identical version of the sheet as a row report. Think that's the only workaround for now.

Adrian Mandile CHESS

Hi @Loann McGee, yes, it is subscription-based, but only about $200/user/yr.

NeilKY

has anyone created a new link to vote on the sorting features suggested by Smartsheet by the voting icon?

SSFeatures

I'm also running into the same issue of not being able to sort multiple columns in the table view at the same time.

Quick Links

Trending ideas

Report Widget Capability - Drag & Drop to create Report Widget in Dashboard from Workspace Panel
Hi, I was creating new dashboard and thought it'll be so nice to have easy drag and drop Report widget capability from Workspace Panel since I always group set of reports under one folder (for ease of finding them what goes on the dashboard). I think this would be great time saver especially if you have similar name…
Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
Asset Sharing should default to View, not Edit
Since the license model has changed, the option to Share should default to VIEW, not EDIT. The View option allows less-experienced users to share that way by default, and share as Edit only when needed. This allows for less cleanup during true-up. This also prevents users from adding provisional licenses unknowingly.