StaySorted now does multi-level sort of up to three different fields.
@PTimaan
10 күн бұрын
hi, sorry what to do if there are two rows for the header?
@ProlificOaktree
9 күн бұрын
Select the table’s range starting with the second header row and tell the add-on that it has a header.
@AmateurleagueSC2
10 ай бұрын
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
10 ай бұрын
Use the FILTER function or QUERY for that. sheetshelp.com/filter/
@AmateurleagueSC2
10 ай бұрын
@@ProlificOaktree Thank you so much, keep up the great work!
@timconsidine6023
27 күн бұрын
Thank you for posting this. Great concise tutorial for very useful function I didn't not realize even existed!
@ProlificOaktree
26 күн бұрын
Thanks, glad you liked it!
@thequirkyexpert
8 ай бұрын
This doesn't work if your data is more complicated. It mixed my data and put contact information under the wrong business name.
@ProlificOaktree
8 ай бұрын
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/
@saben3462
4 ай бұрын
how to do this when you change a dropdown
@ProlificOaktree
4 ай бұрын
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?
@executivefunction
10 ай бұрын
For some reason, I don't see the orange options to add in the sort order and ascending when I try this.
@ProlificOaktree
10 ай бұрын
What is the timestamp in the video? I want to be sure of what you are asking.
@foralimitedtimeonly4976
10 ай бұрын
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
10 ай бұрын
The SUBTOTAL function can skip hidden rows.
@WildPotionLondon
10 ай бұрын
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
10 ай бұрын
Good morning! Let’s get something worked out!
@elevatedtrainingchannel5146
5 ай бұрын
It shows that StaySorted is on a free trial and is $60 a year after trial ends in 7 days. Is this correct?
@ProlificOaktree
5 ай бұрын
Yes (well, $59).
@KELUInvestments
Ай бұрын
Pretty simple yet affective, thank you for great.. great video
@ProlificOaktree
Ай бұрын
Glad you liked it!
@sarachjituatrakul5671
7 ай бұрын
Ez than use Apps Script thanks
@lafamillecarrington
8 ай бұрын
I have been using Query for this. So much more powerful than Sort.
@ProlificOaktree
8 ай бұрын
QUERY is great, but it doesn't rearrange the original data. StaySorted is for users who want one list, not a new dynamic one.
@asishmathewjohnson
8 ай бұрын
Can we add different sort criteria for different tabs in the same Google sheet using this add on?
@ProlificOaktree
8 ай бұрын
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!
@michaelkwiatkowski3732
3 ай бұрын
all i get is errors reading Ref! and it won't sort anything new I put in
@ProlificOaktree
3 ай бұрын
I'd be glad to help you out. Email me at adam@sheetshelp.com and I can setup a video call to see why.
@ghilangrmg5550
10 ай бұрын
Hi thank you for the great video, I'm just wondering if the data sorted by multiple of column.. does it possible?
@ProlificOaktree
10 ай бұрын
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.
@sparkmakerlab8158
10 ай бұрын
"Something went wrong when executing the add-on." :(
@ProlificOaktree
10 ай бұрын
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
@snowman_web_design_development
Ай бұрын
Exactly what I was looking for, thanks!
@ProlificOaktree
Ай бұрын
Glad I could help!
@tracybuford9243
9 ай бұрын
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
9 ай бұрын
oh i used the download StaySorted
@ProlificOaktree
9 ай бұрын
Are you good to go now?
@tracybuford9243
9 ай бұрын
@@ProlificOaktree sorry just saw this. Worked perfectly. Thank you
@AmirAkram-nd7hd
5 ай бұрын
*How do I arrange or filter a chart (spark Line) in ascending order in Google Sheets?*
@ProlificOaktree
5 ай бұрын
Sheets doesn't know what criteria by which to rank sparklines. They're data visualizations, not numbers or strings.
@AmirAkram-nd7hd
5 ай бұрын
@@ProlificOaktree *could you please suggest what should I do to solve this problem*
@ProlificOaktree
5 ай бұрын
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.
@SuheypAta
10 ай бұрын
I don't know why but it didn't work with me
@ProlificOaktree
10 ай бұрын
Get in touch with me if you want to work through it. sheetshelp.com/contact/
@vanexadvertising8250
7 ай бұрын
Is this a google chrome extension?
@ProlificOaktree
6 ай бұрын
No, it is a Google Workspace add-on. It runs in any browser, not just Chrome.
Пікірлер: 51