API & Developers

API & Developers

Connect with other developers from around the world and collaborate on ideas using the Smartsheet API.

Auto-Sorting sheet hacks

✭✭✭
edited 03/27/24 in API & Developers

Hey guys!

I've long been searching for a way to make one specific sheet auto-sort, without having to create individual reports. I know this has been a requested feature for ages and that it's in the works. I was curious if anyone has come up with any clever workarounds that can be used while we're all anxiously waiting?

I have one specific sheet that I use as a main "pipeline" to track individual loans my team is working on. We need the sheet to sort by Priority, and then by closing date. We get new loans throughout the day, so we're constantly having to re-sort it. The pipeline itself can get very lengthy and cluttered, and we found it easiest for each user to have their own filter showing only the loans in their name.

To have the same kind of functionality, I'd have to create an individual report for each user in order to get it to auto-sort for everyone correctly, and it just seems like such a waste of time.

Thanks in advance.

Answers

  • ✭✭✭✭✭✭

    @TinkoLP Have you tried to create the report to filter by Current User in the Assigned to field? This should make it to where you only have to create one report.

  • ✭✭✭

    I have - the problem is we have a "team" account, so the users don't necessarily all have their own accounts.

  • ✭✭✭✭✭
    edited 03/28/24

    Hi @TinkoLP , If you have a "team" account, I'm curious how you plan to sort by an individual. Also, why not get everyone their own account? I don't think they would need a license.

    Do you have access to creating a dynamic view? If so, you could set up filters for each user. The way I have done this is to create a "template" filter with all of the relevant fields. Then the individual user can copy that template and modify it according to their needs. SS will remember the filters that individuals set up.

    Good luck and be well!

    If my response was helpful or answered your question please be sure to upvote it, mark it asawesome, or mark it as the accepted answer!

  • ✭✭✭✭✭

    Hi @TinkoLP, I created a browser extension (SSFeatures) to make this possible. SSFeatures adds this "Sort Automatically" button, that you can click, then SSFeatures will sort your data automatically whenever it changes.

    Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com)

    SSFeatures - The browser extension that adds essential features into Smartsheet.

Trending in API & Developers