Auto-Sorting a Sheet
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.
Answers
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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?
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives