Auto-Sorting a Sheet

BradJoseph

Hello,

I am trying to figure out how to auto-sort a sheet so that when I open it a specific column will be automatically sorted by a-z. I realize that it is simple to just sort it myself when I open it but this form is not used by just myself, it is used by dozens and dozens of people, many of them very computer illiterate and they are all over the country and constantly changing. I don't want to have to teach people how to sort rows several times every day when i have much more valuable things I could be doing with my time.

This problem would fix itself if when the sheet is opened a specific column would be automatically sorted for everyone by a-z.

Suggestions regarding reports will not be helpful, nor will "just train your staff" or "hire computer literate people". This sheet requires that it is opened multiple times every day by multiple people in all walks of life throughout an entire country so that they can enter meta data. A specific row needs to be sorted a-z, that simple, the headache and endless emails and phone calls I have been receiving can be all fixed by one simple feature.

Thank you anyone who is able to help.

Andrée Starå

Hi @BradJoseph

I hope you're well and safe!

Great idea! That would be a great addition to Smartsheet features.

Please submit an Enhancement Request when you have a moment.

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!

Jeanette_at_Bose

I read on another thread that saving sort criteria in a sheet was in the product roadmap in 2018. Why is this not done yet? This is VERY basic functionality and makes it practically useless to not have it. Can we get an update on this please?

CAS the CSA

Still nothing? I hit a roadblock trying to have rows moved via automation land at the top of the sheet.

Alternatively I thought we could work around it by auto sorting the sheet when we refresh to move newly moved rows from the bottom to the top. but no.

I do NOT want to create a row report just to see new rows at the top.