Sorting a column after running Data Shuttle

I have several workflows that run in Data Shuttle to update a sheet. I want the sheet to always be sorted by "column A", but after the workflows run, I have to manually sort the sheet by "column A" in order to keep the sheet appearing correctly. Is there a way to insure the sheet is always sorted by "column A" so i don't have to sort it manually after the workflows run? I want to have the workflows set to run at certain time, with collaborators able to see the updates, but without the sheet sorted correctly, the information in the sheet is not usable.

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

Hi @Mitch Cohen

What I would do in this instance is create a Row Report from the sheet and use this as the "working sheet" instead:

Reports will stay locked in a Sort so as new rows are added or updated they will appear in the correct order.
You can make changes to data in a Report which will automatically show in the underlying sheet.

Please also feel free to Vote and add your voice to this Idea post in the Product Features and Ideas topic: Auto sort rows in sheet

Cheers,

Genevieve

Chizu Hieida

@Genevieve P. I wish there was easier way to convert these type of post to "New Idea" submission. I found 2 of the similar request when I was searching resolution to similar problems I currently have. Neither of them were under "New Idea" so can't "Vote" (I can vote the post but I don't think it counts as new product idea. It would be nice to have easier topic conversion from question > New Idea —- just something to think about. It removes extra steps and make it easier for new idea submission. :)

Genevieve P.

Hey @Chizu Hieida

Thanks for your feedback! You're correct, any post/question that is here in the Community from before we launched the Product Ideas section, or that came in first as a question (and then was directed to the Ideas section) can't be auto-converted.

To help with your search though, you can filter by the Ideas section in order to only see discussions you can vote on!

If you don't find your request after filtering please feel free to create a new Idea so others can vote 🙂

Cheers,
Genevieve

Chizu Hieida

@Genevieve P. Oh darn it. maybe that'll be "New Product Idea" :D hahahaha

I did see other question article and I'm trying to create the workaround using Power Automate & Office Scripts to just do this function —- but running into hiccups and would love this function for sure. I'll see if I have a time tomorrow to submit new product idea :) Thanks!

SSFeatures

Hi @Mitch Cohen, I built a browser extension (SSFeatures) that allows you to automatically sort your data whenever it changes.

With the extension, open the "Sort Rows" menu and then click on this "Sort Automatically" button.

Hope this helps!

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.