Automatically Sort New Rows in Google Sheets

[@ProlificOaktree]

StaySorted now does multi-level sort of up to three different fields.

[@KELUInvestments]

Pretty simple yet affective, thank you for great.. great video

[@ProlificOaktree]

Glad you liked it!

[@hadfina9675]

It works! Thanks alot

[@ProlificOaktree]

You're welcome!

[@AmateurleagueSC2]

Hi, great video. Just wondering if you know a way to create a results page that is sorted and only displays 3 of 7 rows of data?

[@ProlificOaktree]

Use the FILTER function or QUERY for that. sheetshelp.com/filter/

[@AmateurleagueSC2]

@@ProlificOaktree Thank you so much, keep up the great work!

[@lafamillecarrington]

I have been using Query for this. So much more powerful than Sort.

[@ProlificOaktree]

QUERY is great, but it doesn't rearrange the original data. StaySorted is for users who want one list, not a new dynamic one.

[@krishnatate4765]

Excellent 👍🏻

[@ProlificOaktree]

Thanks for the visit

[@ghilangrmg5550]

Hi thank you for the great video, I'm just wondering if the data sorted by multiple of column.. does it possible?

[@ProlificOaktree]

Yes, it does three levels of sorting. That was added after this video. If you install the add-on, the new capability will be there.

[@executivefunction]

For some reason, I don't see the orange options to add in the sort order and ascending when I try this.

[@ProlificOaktree]

What is the timestamp in the video? I want to be sure of what you are asking.

[@foralimitedtimeonly4976]

Is there a formula to dynamically track the visible rows after sorting and totaling them? I have a Transaction sheet with 10 rows of data. When I sort I want the items in the Amount column to get totaled and placed in The Grand Totals column. Is right now is it's adding ALL Amounts and displaying it in the Totals and if I sort but another criteria the Grand Total stays the same instead of changing to only what is showing.

[@ProlificOaktree]

The SUBTOTAL function can skip hidden rows.

[@michaelkwiatkowski3732]

all i get is errors reading Ref! and it won't sort anything new I put in

[@ProlificOaktree]

I'd be glad to help you out. Email me at [e-mail] and I can setup a video call to see why.

[@asishmathewjohnson]

Can we add different sort criteria for different tabs in the same Google sheet using this add on?

[@ProlificOaktree]

No, that's been a popular question lately though. Thanks for letting me know. If enough people ask, I'll try to figure out how to do that!

[@elevatedtrainingchannel5146]

It shows that StaySorted is on a free trial and is $60 a year after trial ends in 7 days. Is this correct?

[@ProlificOaktree]

Yes (well, $59).

[@WildPotionLondon]

Do you do an affiliate program for this? Also, I'm creating a Google sheet which I will be selling to a group of people. I have added 'Stay Sorted' to the sheet, therefore, anyone that buys the sheet will have to purchase it also in order for certain data to automatically update I guess?

[@ProlificOaktree]

Good morning! Let’s get something worked out!

[@AmirAkram-nd7hd]

*How do I arrange or filter a chart (spark Line) in ascending order in Google Sheets?*

[@ProlificOaktree]

Sheets doesn't know what criteria by which to rank sparklines. They're data visualizations, not numbers or strings.

[@AmirAkram-nd7hd]

@@ProlificOaktree *could you please suggest what should I do to solve this problem*

[@ProlificOaktree]

That question is too vague to answer in a meaningful way. I would have to spend some time in your spreadsheet and then talk it through with you. Best of luck my friend.

[@saben3462]

how to do this when you change a dropdown

[@ProlificOaktree]

It works with drop-downs like a text string or number, depending on what's in the dropdown. It shouldn't be a problem. Are you experiencing issues?

[@tracybuford9243]

ok This was really helpful but for some reason my information in other columns keeps getting mixed up when my spreadsheets automatically sorts. Any ideas of what I may have done wrong?

[@tracybuford9243]

oh i used the download StaySorted

[@ProlificOaktree]

Are you good to go now?

[@tracybuford9243]

@@ProlificOaktree sorry just saw this. Worked perfectly. Thank you

[@sarachjituatrakul5671]

Ez than use Apps Script thanks

[@vanexadvertising8250]

Is this a google chrome extension?

[@ProlificOaktree]

No, it is a Google Workspace add-on. It runs in any browser, not just Chrome.

[@thequirkyexpert]

This doesn't work if your data is more complicated. It mixed my data and put contact information under the wrong business name.

[@ProlificOaktree]

Mixing the data in the rows should not be related to the complexity of the data. It is like a regular sort in that way. As long as you capture all the columns, the rows stay intact. If you want to reach out to me and share the spreadsheet, I can help you troubleshoot. Sorry you had issues with it. sheetshelp.com/contact/

[@user-wn2ju1qp4n]

I don't know why but it didn't work with me

[@ProlificOaktree]

Get in touch with me if you want to work through it. sheetshelp.com/contact/

[@sparkmakerlab8158]

"Something went wrong when executing the add-on." :(

[@ProlificOaktree]

Oh, that's not good. It could be an administrator setting if you're using an organizational account. Let me know if you want me to look at it. Shoot me a message at [e-mail]