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.
We added this feature to the add-on now so you can have different active sorts on different sheets. Let me know if you want me to reset your trial. adam@sheetshelp.com
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?
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.
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?
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/
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
StaySorted now does multi-level and multi-range sorts.
Thank you for posting this. Great concise tutorial for very useful function I didn't not realize even existed!
Thanks, glad you liked it!
Thank you very much, your explanation is extremely clear and easy
You are welcome!
Pretty simple yet affective, thank you for great.. great video
Glad you liked it!
Exactly what I was looking for, thanks!
Glad I could help!
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?
Use the FILTER function or QUERY for that. sheetshelp.com/filter/
@@ProlificOaktree Thank you so much, keep up the great work!
Excellent, thank you.
You are welcome!
I have been using Query for this. So much more powerful than Sort.
QUERY is great, but it doesn't rearrange the original data. StaySorted is for users who want one list, not a new dynamic one.
Hi thank you for the great video, I'm just wondering if the data sorted by multiple of column.. does it possible?
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.
For some reason, I don't see the orange options to add in the sort order and ascending when I try this.
What is the timestamp in the video? I want to be sure of what you are asking.
hi, sorry what to do if there are two rows for the header?
Select the table’s range starting with the second header row and tell the add-on that it has a header.
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.
The SUBTOTAL function can skip hidden rows.
Can we add different sort criteria for different tabs in the same Google sheet using this add on?
We added this feature to the add-on now so you can have different active sorts on different sheets. Let me know if you want me to reset your trial. adam@sheetshelp.com
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?
Good morning! Let’s get something worked out!
*How do I arrange or filter a chart (spark Line) in ascending order in Google Sheets?*
Sheets doesn't know what criteria by which to rank sparklines. They're data visualizations, not numbers or strings.
@@ProlificOaktree *could you please suggest what should I do to solve this problem*
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.
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?
oh i used the download StaySorted
Are you good to go now?
@@ProlificOaktree sorry just saw this. Worked perfectly. Thank you
It shows that StaySorted is on a free trial and is $60 a year after trial ends in 7 days. Is this correct?
Yes (well, $59).
all i get is errors reading Ref! and it won't sort anything new I put in
I'd be glad to help you out. Email me at adam@sheetshelp.com and I can setup a video call to see why.
It works! Thanks alot
You're welcome!
Is this a google chrome extension?
No, it is a Google Workspace add-on. It runs in any browser, not just Chrome.
This doesn't work if your data is more complicated. It mixed my data and put contact information under the wrong business name.
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/
how to do this when you change a dropdown
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?
Excellent 👍🏻
Thanks for the visit
Ez than use Apps Script thanks
"Something went wrong when executing the add-on." :(
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
I don't know why but it didn't work with me
Get in touch with me if you want to work through it. sheetshelp.com/contact/