Automatic sorting

Hi Matt,

Please submit an Enhancement Request when you have a moment to have your vote added

A New Way to Submit Your Feature Requests

To make your Enhancement / Feature Request count, send in the form above because there isn’t a guarantee, it will be registered otherwise.

Original Post: https://community.smartsheet.com/announcement/new-way-submit-your-feature-requests

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

I'm also finding this very annoying, especially since you can't sort when you have a filter on.

I'm using Smartsheet for a simple Open Items list with Priority and Due Date columns. We are frequently adding new Open Items and needing to re-sort by the Priority, then Due Date columns. I have placed both columns next to each other so I can easily highlight them, right-click, then sort. But my default filter is set to only show uncompleted items. So I have to turn the filter off, re-sort, then turn the filter back on. It's really tedious.

Personally, I don't need an automatic sort. I'd be happy with a button on the sheet that allowed me to re-sort with the click of the button. It would need to work even with a filter turned on.

I agree with several others here. Yes, we can create (yet) another report, but sometimes we'd like to keep things simple.

I have a sheet that priority ranks tasks based on progress and importance - so the priority ranks change all the time as people make progress and time marches on. I can and do get personalised reports to sort and filter for users, but it shouldn't be too hard to enable the sheet itself to always be sorted by task priority number or whatever column you wish?

Even better would be to be able to have the facility to combine prioritisation options in the filters users can create. That would enable quick transfer between different views of the same information. e.g. 'Just the current user's tasks by priority order', then 'All tasks classified 'Critical' by due date', then 'Tasks for a team by progress ahead or behind target'. Yes, this begins to look a lot like the functionality provided by reports, but these examples would require three reports (each with their own security/sharing settings) as well as the base sheet and I don't always want multiple reports to look after. The functionality is all in the Sheet, I just want it to be quicker to get to.

Really quite surprised this is not an option from the get go. I actually could have sworn I saw one of the your smart sheet integrator doing it in our Webinar unfortunately I only could only hold half of my attention at that time and didn't get the recorded video to confirm.

To my point not being able to do this is quite crippling for simple functionality. reports are powerful and useful but are limiting even if they are "live".

Curious if anyone has come to resolve with this missing feature?

I have one idea, which would create more sheets, would be to use the automate feature and have the dire need objectives get copied to a need to complete today/week sheet. the only other issue is the lack of 'linked cells' so if you made a change on that today/week sheet it would not auto-update the same info on the parent sheet as I understand it. I could also see using the same automate tool though to create an automatic update on the parent sheet. none of this is tested but just a thought. if I get around to doing it I'll try to update here on my findings. If someone does give it a shot I would like to hear about what they did and any issues they ran into.

Thanks for everyone's time reading this!

For Auto sort, I realize there are some complications, but it could be set up as an automation, to periodically (every x hours or days) to re-sort a sheet based on specific columns.

I agree with all of the above. I'll submit an enhancement request but won't be holding my breath. Obviously not a priority for the developers :(

For now I'd be happy for a way to sort with a filter on. The process could be to turn the filter off, sort, and then put the original filter back on. I agree having an instantaneously automatic sort or an automation sort would be great as well.