Auto-Sorting sheet hacks

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.

Find more posts tagged with

Sheets

API and Developers

Automations

Product Development

Workflows in Smartsheet

Accepted answers

All comments

JamesB

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

TinkoLP

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

Scott Orsey

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!

SSFeatures

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.

prime_nathaniel

@TinkoLP

If you have bridge with the new user model pricing it is very easy to do, create a webhook when new row is added to sheet. Process that webhook in bridge, bridge calls API to sort the sheet. Now everytime a new row goes in, it ensures it ends up in the right place.

NeilKY

https://community.smartsheet.com/discussion/comment/479033#Comment_479033

This was simple but useful information, I was able to make something quickly with your info. Thanks!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.