Auto Sort Smartsheet
I've seen a few threads about this already, but none seem to have an acceptable solution. My particular use case is this:
We have a Master Schedule sheet with over 100 active projects (this sheet is updated by various project managers). Every Monday morning we open this sheet and review all projects that match a particular filter I've set up. There are also various other filters that help review the projects by department, project manager, etc.
Here's the problem:
There appears to be no way to automatically sort the sheet when a new project is added, which could cause huge problems during our company wide meeting if rows are not sorted at the beginning of every meeting.
It seems everyone is recommending using a report instead of the source sheet, so the data is automatically sorted. While I could accept having to add new projects in one sheet while reviewing data in a report, I cannot accept losing the ability to then filter the data. I would have to create a separate report for each filter I currently have set up. This would be far too cumbersome, for something that could easily be done with a single Google Sheet.
I cannot understand why auto-sorting is not an option in Smartsheet, but I would love to hear any solutions you may have for this particular situation. I've tried Zapier, but I don't see a way to sort a sheet based on a trigger.
Best Answer
-
Hi Cory,
Unfortunately, as you've noticed, it's not possible at the moment, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment to have your vote added
I'll get back to the post if I think of something that could help!
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it 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.
Answers
-
Hi Cory,
Unfortunately, as you've noticed, it's not possible at the moment, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment to have your vote added
I'll get back to the post if I think of something that could help!
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it 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.
-
second the need to sort! i can sort reports and thats fine, but i need to make charts and pivots that are sorted and also need to apply formulas to the sorted items and we all know that reports can't have formulas added and can't be referenced in charts and things.
I thought that a pivot table would sort items in the same order as a report- is that not true? I really need some metrics on my dashboard to be in order, so I thought a sheet->Report->Pivot table would be a great workaround, but alas, my pivot table continues to not be sorted in the same way the report is.
Would love some help on this!
-
Please add AUTO SORT to SmartsheetGov too!!
-
+ 1 on Auto sort!
-
+1 pls
-
yes please add autosort
-
It's almost 2 years since this issue was raised. It's a very useful feature and I don't understand why it takes so long to be implemented.
Please advise if smartsheet has any timeline to implement this.
-
I just sent a request to add the autosort feature. So +1 for me!!!
-
This would be so helpful - especially when it comes to using data shuttle to update dropdown lists! Or at least let me use reports to import/export for dropdowns!
-
Hear our Cries Smartsheet. Please implement Autosort!
-
I concur that Auto Sort is a necessary and logical feature. The fact that it has not materialized in over a year of asks is telling.....🤨
-
We use Smartsheet as a operations logbook. Manual sorting by a set of columns is a mess by different operators is a mess. Please add an Auto Sort!
-
Surprised Auto Sort still isn't a thing. This would be very useful.
-
Auto sort please it will be really helpful
-
Yes please. If not auto-sort, give us an automation to sort a column.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives