Automatic sorting

Automatic sorting

i have a sheet that has data with dates added from a form. it always adds a new request from the form to the top and i have to manually sort it by date in descending. is there not a way to have it automatically add the data by the date in descending order?

Tagged:

Comments

  • Mike WildayMike Wilday ✭✭✭✭✭

    You can either set the form options to add the row to the bottom of the sheet, or you can create a report to sort the data automatically. 

    See screenshot for setting where your form entries appear. 

    https://help.smartsheet.com/node/522221#manageform

    https://help.smartsheet.com/articles/522214-creating-reports

    2018-04-03_11-27-31.jpg

  • Thank you but i need it to sort on the sheet itself and not a report.

    we use this for our employees to request PTO. We need it to sort by the day they are requesting off. right now it just can either put the request on top or bottom with no matter of the date it is for.

  • Mike WildayMike Wilday ✭✭✭✭✭

    Hi Lisa, 

    Auto-sorting is not possible in the original smartsheet. Is there a specific reason why a report that includes every column in the main sheet, sorted by the request date wouldn't work? If you have access to all the data in the report, and can make changes to any of those rows, why wouldn't a report work? 

  • the report aspect is not what we are looking for because our employees are already complaining about all the different sites, systems, and sheets they have to use. if we add another place they have to go other than the sheet they have been using for 2 years now and finally use to, they will lose their minds lol.

    i will just manually keep doing it i guess

  • Mike WildayMike Wilday ✭✭✭✭✭

    Hi Lisa, I totally understand. laugh

  • Smartsheet people:

    I want the auto sort functionality as well.  I don't want extra reports and workarounds, I want my main sheet to keep itself sorted on several levels according to criteria I can set. 

    Don't tell me that your product can't do this:  that only means it is an inferior and weak tool that doesn't work well for me. 

    Make this a MAJOR priority for the team programming new capabilities and features and MAKE it happen. 

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Chris,

    It seems like something like this is coming later in the year. I'm not 100% sure that it will do exactly what you want. It will automatically move rows or cells it seems.

    We will know the details later this year.

    Can you tell me more about how you would want to use it?

    I hope this helps you!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Hi Andree

    I too have found issue with Smartsheet not having an automatic sorting function and i highly recommend that users are given this option.

    My team needs to filter through a lot of rows and more often than not the user struggles to find the row they are looking for.  Sorting the rows consistantly is a way of making this easy.

    For example my team uses the sheet as a league table of projects with the best at the top.  Its keeps it recognisable.  However this requires manually sorting the sheet, and that can only be done by the admin user.

    Automatic sort function would be a game changer!  I can imagine all businesses would benefit from this function.

    Please implement asap!

    Thanks

    Chris

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Best option at the moment is filters or reports.

    Please submit an Enhancement Request when you have a moment.

    Best,

    Andrée

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • I'll be very pleased to see it happen.  

    I track projects in a sheet and I keep it organized by delivery due date.  I usually have a filter applied that hides all completed projects so I am only looking at the ones we are currently working on.  Any time I add a project or change a due date. I have to disable the filter, re-sort the sheet ascending on the Delivery Date column, and then turn the filter back on.  It is a clunky and cumbersome process... if I change that date on a project, I want it to simply jump up or down in the order accordingly the moment I enter the new date. (Perhaps this should default to a 'confirm re-sort' dialogue - that I could turn off). 

    Even having to turn the filter off to sort the sheet grinds my gears every time - I should be able to sort without disabling the filter.

    Also - right now I don't bother with multiple tiers of sort, since i have to redo manually every time.  I should be able to set up a Sort as a named preset much the way that Filters operate.

    Chris

  • edited 12/26/18

    I work as a service coordinator and our entire region is considering switching over to Smartsheet so I'm looking into functionality setbacks. Not having an autosort is one of them. We are continually adding data (we schedule up to 100 appointments a day) and then having to resort when working in the main sheet because the data does not populate by sort criteria and I cannot save sort criteria to simply click a button and resort either. This is extremely ineffective from a time management standpoint and from a resource management standpoint. I cannot work off a report because I need to see the current active data for any given tech (or more than one) in any given time slot and area, by date and then be able to add an appointment and see that appointment in order so that I can schedule further appointments around existing ones.



    Is there a solution upcoming for the lack of expanded sort functionality?

  • Mike WildayMike Wilday ✭✭✭✭✭

    Hi Art, 

    Based on your needs I don't see a huge issue with using a report. You could set up a quick form for creating new appointments. And then just refresh your report to see the sorted information including the new appointments. The only drawback to the reports is that you can't enter new rows on a report. But if you have a simple link to add a new appointment via a form, you could then just refresh the report to include the new sorted row. 

    Reports are always "live" views of all the data from the original sheet(s). So if data gets updates in Smartsheet and you refresh your report it will be the most current. And you can include all the users OR limit it to particular users so there won't be any issue there. 

    Let us (the community) know if you have any questions or concerns and we'd be glad to give you feedback or input. 

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Art,

    Please submit an Enhancement Request when you have a moment.

    Happy Holidays & Happy New Year!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • I agree! I've added an enhancement request, but wanted to cast my vote here as well.

    I very much need a solution that creates the correct sort *in the sheet* so my team has the information easily accessible and sorted when they enter new data. A report can also be resorted by users, so it doesn't solve the problem - even if it wasn't problematic in other ways.

    A big "please make this happen" from me!

  • Hello,

     

    I would much love to have a way to auto-sort a smartsheet; I am using it to share the backlog with my managers, and I need to sort it by priorities and date; I can use the sort algorithm, but it does not memorize the only choice I always make, and that's driving me crazy.

     

    I think you should really consider having a "Re-sort" button that memorizes the last sorting settings requested and re-do it; a truly automatic would be even nicer of course, but I can understand it's harder to implement.

  • Hello Smartsheet, I am adding my vote to the "auto sorting/saved sort" requests above. Please prioritize some version of this. Like others, I have found a low adoption rate for custom reports because it's one more tool/URL to which employees have to pivot. When security risks are low, a single shared Smartsheet works best. Within that shared Smartsheet, filters are very useful, but they don't address the sorting problem. - Matt

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    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

    work-bold

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • One year later >> is there anything implemented that allows me to do that?

     

    I've a "Todo - Sorting" column, calcualted from various values - i want the highest value to be on top; needs resorting at least "once a day".

    Filter off, resort, filter on - each time forced to reconfigure the resorting is exhausting.

  • 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.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Tim,

    As a possible workaround, you could use reports instead. (As mentioned earlier in the thread, but I don't know if you're aware or seen it)

    Also, Please submit an Enhancement Request when you have a moment to have your vote added to add the feature to the sheets.

    Would that work?

    I hope that helps!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • 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.

  • One of the beautiful things about a SAS application is being able to have multiple people updating the information simultaneously.

    The frustration has been pointed out here MANY times... As updates are made or a sheet is reopened you have to manually redo the sort which just seems archaic.

    PLEASE PLEASE PLEASE create a DEFAULT SORT option like you have a DEFAULT FILTER option in sheet sharing.

    Thanks, Michael

  • 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!

Sign In or Register to comment.