Тёмный

Automatically Sort New Rows in Google Sheets 

Prolific Oaktree
Подписаться 50 тыс.
Просмотров 10 тыс.
50% 1

StaySorted - bit.ly/POstaysorted. Now with multi-level sort. Learn two methods to keep your data constantly sorted. One method is a function, and the other is an add-on.
2023 Update: Multi-level sort is now available in the add-on
Timestamps:
0:00 Intro
0:57 Demonstration of unsorted data
1:42 SORT Function
5:14 StaySorted Add-On
#spreadsheet #googlesheets #staysorted

Наука

Опубликовано:

 

16 июн 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 43   
@ProlificOaktree
@ProlificOaktree 6 месяцев назад
StaySorted now does multi-level sort of up to three different fields.
@hadfina9675
@hadfina9675 8 месяцев назад
It works! Thanks alot
@ProlificOaktree
@ProlificOaktree 8 месяцев назад
You're welcome!
@krishnatate4765
@krishnatate4765 9 месяцев назад
Excellent 👍🏻
@ProlificOaktree
@ProlificOaktree 9 месяцев назад
Thanks for the visit
@ghilangrmg5550
@ghilangrmg5550 7 месяцев назад
Hi thank you for the great video, I'm just wondering if the data sorted by multiple of column.. does it possible?
@ProlificOaktree
@ProlificOaktree 7 месяцев назад
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.
@AmateurleagueSC2
@AmateurleagueSC2 7 месяцев назад
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
@ProlificOaktree 7 месяцев назад
Use the FILTER function or QUERY for that. sheetshelp.com/filter/
@AmateurleagueSC2
@AmateurleagueSC2 6 месяцев назад
@@ProlificOaktree Thank you so much, keep up the great work!
@lafamillecarrington
@lafamillecarrington 4 месяца назад
I have been using Query for this. So much more powerful than Sort.
@ProlificOaktree
@ProlificOaktree 4 месяца назад
QUERY is great, but it doesn't rearrange the original data. StaySorted is for users who want one list, not a new dynamic one.
@JUICEMEDIC
@JUICEMEDIC 6 месяцев назад
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
@ProlificOaktree 6 месяцев назад
Good morning! Let’s get something worked out!
@foralimitedtimeonly4976
@foralimitedtimeonly4976 6 месяцев назад
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
@ProlificOaktree 6 месяцев назад
The SUBTOTAL function can skip hidden rows.
@asishmathewjohnson
@asishmathewjohnson 4 месяца назад
Can we add different sort criteria for different tabs in the same Google sheet using this add on?
@ProlificOaktree
@ProlificOaktree 4 месяца назад
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!
@executivefunction
@executivefunction 6 месяцев назад
For some reason, I don't see the orange options to add in the sort order and ascending when I try this.
@ProlificOaktree
@ProlificOaktree 6 месяцев назад
What is the timestamp in the video? I want to be sure of what you are asking.
@AmirAkram-nd7hd
@AmirAkram-nd7hd 2 месяца назад
*How do I arrange or filter a chart (spark Line) in ascending order in Google Sheets?*
@ProlificOaktree
@ProlificOaktree 2 месяца назад
Sheets doesn't know what criteria by which to rank sparklines. They're data visualizations, not numbers or strings.
@AmirAkram-nd7hd
@AmirAkram-nd7hd Месяц назад
@@ProlificOaktree *could you please suggest what should I do to solve this problem*
@ProlificOaktree
@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.
@michaelkwiatkowski3732
@michaelkwiatkowski3732 9 дней назад
all i get is errors reading Ref! and it won't sort anything new I put in
@ProlificOaktree
@ProlificOaktree 5 дней назад
I'd be glad to help you out. Email me at adam@sheetshelp.com and I can setup a video call to see why.
@elevatedtrainingchannel5146
@elevatedtrainingchannel5146 2 месяца назад
It shows that StaySorted is on a free trial and is $60 a year after trial ends in 7 days. Is this correct?
@ProlificOaktree
@ProlificOaktree 2 месяца назад
Yes (well, $59).
@sarachjituatrakul5671
@sarachjituatrakul5671 3 месяца назад
Ez than use Apps Script thanks
@tracybuford9243
@tracybuford9243 5 месяцев назад
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
@tracybuford9243 5 месяцев назад
oh i used the download StaySorted
@ProlificOaktree
@ProlificOaktree 5 месяцев назад
Are you good to go now?
@tracybuford9243
@tracybuford9243 5 месяцев назад
@@ProlificOaktree sorry just saw this. Worked perfectly. Thank you
@vanexadvertising8250
@vanexadvertising8250 3 месяца назад
Is this a google chrome extension?
@ProlificOaktree
@ProlificOaktree 3 месяца назад
No, it is a Google Workspace add-on. It runs in any browser, not just Chrome.
@saben3462
@saben3462 15 дней назад
how to do this when you change a dropdown
@ProlificOaktree
@ProlificOaktree 13 дней назад
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?
@thequirkyexpert
@thequirkyexpert 4 месяца назад
This doesn't work if your data is more complicated. It mixed my data and put contact information under the wrong business name.
@ProlificOaktree
@ProlificOaktree 4 месяца назад
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
@user-wn2ju1qp4n 6 месяцев назад
I don't know why but it didn't work with me
@ProlificOaktree
@ProlificOaktree 6 месяцев назад
Get in touch with me if you want to work through it. sheetshelp.com/contact/
@sparkmakerlab8158
@sparkmakerlab8158 6 месяцев назад
"Something went wrong when executing the add-on." :(
@ProlificOaktree
@ProlificOaktree 6 месяцев назад
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
Далее
Sort and Filter - New Features for Google Sheets
14:52
Automatically Sort Data in Google Sheets
13:23
Просмотров 134 тыс.
Zoom x100 всего лишь маркетинг
00:41
Просмотров 189 тыс.
FUN&SUN | Update 0.29.0 Trailer | Standoff 2
02:32
Просмотров 1,2 млн
Tug’riq avval va hozir 2😂😂
00:44
Просмотров 711 тыс.
How to automatically sort values as they are entered
4:04
New 2024 Table Feature in Google Sheets!
24:02
Просмотров 7 тыс.
How to Auto Sort in Google Sheets - The Best Way!
4:40
How to Automatically Alphabetize in Google Sheets
5:29
How to Auto Sort Data in Google Sheets
3:15
Просмотров 30 тыс.
Main filter..
0:15
Просмотров 5 млн
Купил этот ваш VR.
37:21
Просмотров 234 тыс.
ВЫ ЧЕ СДЕЛАЛИ С iOS 18?
22:40
Просмотров 119 тыс.
Для фанатов SEGA MEGADRIVE - Anbernic RG ARC
14:23
Девушка и AirPods Max 😳
0:59
Просмотров 16 тыс.