Auto Sort Sheet

Sarah_Ko · 09/24/21

Hi there,

Is there functionality to have an auto sort of data so that I don't have to sort it every time I adjust something? Similar to Excel, where it remembers your sort order?

Thanks.

Andrée Starå · 09/24/21

Hi @Sarah_Ko

I hope you're well and safe!

Here's a possible workaround or workarounds

Have you explored using a Report instead?

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

KMan1190 · 10/25/21

I have the same Question as the OP, anyone know if there is a funtion within sheets to auto sort, or the only solution is the create reports?

Genevieve P. · 10/26/21

Hi @KMan1190

Reports will automatically Sort based on their set-up, but sheets currently do not have this functionality (see: Sort Rows to Organize Your Data)

Please provide your feedback to our Product team through this form, here!

Cheers,

Genevieve @kmalone51256

vto · 07/24/22

Using Reports for auto sorting is not good enough. It's a simple function for auto sorting that will make Smartsheet smarter and better than excel!

Dennis M Wierzbicki · 08/06/22

I have to agree. having a sheet, then needing to create a report JUST to sort the data is a kludge, at best. It would seem adding this functionality to an automation would be perfect.

Auto Sort Sheet

Answers

Categories