StaySorted now does multi-level sort of up to three different fields.
@KELUInvestments9 күн бұрын
Pretty simple yet affective, thank you for great.. great video
@ProlificOaktree8 күн бұрын
Glad you liked it!
@hadfina967510 ай бұрын
It works! Thanks alot
@ProlificOaktree10 ай бұрын
You're welcome!
@AmateurleagueSC29 ай бұрын
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?
@ProlificOaktree9 ай бұрын
Use the FILTER function or QUERY for that. sheetshelp.com/filter/
@AmateurleagueSC29 ай бұрын
@@ProlificOaktree Thank you so much, keep up the great work!
@lafamillecarrington7 ай бұрын
I have been using Query for this. So much more powerful than Sort.
@ProlificOaktree7 ай бұрын
QUERY is great, but it doesn't rearrange the original data. StaySorted is for users who want one list, not a new dynamic one.
@krishnatate476511 ай бұрын
Excellent 👍🏻
@ProlificOaktree11 ай бұрын
Thanks for the visit
@ghilangrmg55509 ай бұрын
Hi thank you for the great video, I'm just wondering if the data sorted by multiple of column.. does it possible?
@ProlificOaktree9 ай бұрын
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.
@executivefunction9 ай бұрын
For some reason, I don't see the orange options to add in the sort order and ascending when I try this.
@ProlificOaktree9 ай бұрын
What is the timestamp in the video? I want to be sure of what you are asking.
@foralimitedtimeonly49768 ай бұрын
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.
@ProlificOaktree8 ай бұрын
The SUBTOTAL function can skip hidden rows.
@michaelkwiatkowski37322 ай бұрын
all i get is errors reading Ref! and it won't sort anything new I put in
@ProlificOaktree2 ай бұрын
I'd be glad to help you out. Email me at adam@sheetshelp.com and I can setup a video call to see why.
@asishmathewjohnson6 ай бұрын
Can we add different sort criteria for different tabs in the same Google sheet using this add on?
@ProlificOaktree6 ай бұрын
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!
@elevatedtrainingchannel51464 ай бұрын
It shows that StaySorted is on a free trial and is $60 a year after trial ends in 7 days. Is this correct?
@ProlificOaktree4 ай бұрын
Yes (well, $59).
@WildPotionLondon9 ай бұрын
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?
@ProlificOaktree9 ай бұрын
Good morning! Let’s get something worked out!
@AmirAkram-nd7hd4 ай бұрын
*How do I arrange or filter a chart (spark Line) in ascending order in Google Sheets?*
@ProlificOaktree4 ай бұрын
Sheets doesn't know what criteria by which to rank sparklines. They're data visualizations, not numbers or strings.
@AmirAkram-nd7hd4 ай бұрын
@@ProlificOaktree *could you please suggest what should I do to solve this problem*
@ProlificOaktree4 ай бұрын
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.
@saben34622 ай бұрын
how to do this when you change a dropdown
@ProlificOaktree2 ай бұрын
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?
@tracybuford92438 ай бұрын
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?
@tracybuford92438 ай бұрын
oh i used the download StaySorted
@ProlificOaktree8 ай бұрын
Are you good to go now?
@tracybuford92437 ай бұрын
@@ProlificOaktree sorry just saw this. Worked perfectly. Thank you
@sarachjituatrakul56715 ай бұрын
Ez than use Apps Script thanks
@vanexadvertising82505 ай бұрын
Is this a google chrome extension?
@ProlificOaktree5 ай бұрын
No, it is a Google Workspace add-on. It runs in any browser, not just Chrome.
@thequirkyexpert6 ай бұрын
This doesn't work if your data is more complicated. It mixed my data and put contact information under the wrong business name.
@ProlificOaktree6 ай бұрын
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-wn2ju1qp4n9 ай бұрын
I don't know why but it didn't work with me
@ProlificOaktree9 ай бұрын
Get in touch with me if you want to work through it. sheetshelp.com/contact/
@sparkmakerlab81588 ай бұрын
"Something went wrong when executing the add-on." :(
@ProlificOaktree8 ай бұрын
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 asteinfurth@alspropertiesllc.com