- Видео 9
- Просмотров 17 913
Dataful
Добавлен 21 янв 2024
Hi! My name is Stan. On this channel I am sharing my experience in developing automation and data flows with Google Sheets, Apps Script, Looker Studio for myself and my clients, as well as the techniques I have honed along the way. Whether you are just starting or are looking to refine your approach, join me on this journey to making data work for you.
#googlesheets #googleappscript #gas #lookerstudio
#googlesheets #googleappscript #gas #lookerstudio
4 Ways to Highlight Duplicates in Google Sheets
Learn 4 ways to highlight duplicates in Google Sheets with conditional formatting.
00:00 Intro
00:26 Simple duplicate
02:15 Entire rows
03:00 Multi-cell duplicates
03:56 Nth+ duplicates
📨 Newsletter: dataful.tech/subscribe/
#gsheets #googlesheets #googlesheetstips #googlesheetstutorial #duplicates #conditionalformating #datamanagement #datacleaning
00:00 Intro
00:26 Simple duplicate
02:15 Entire rows
03:00 Multi-cell duplicates
03:56 Nth+ duplicates
📨 Newsletter: dataful.tech/subscribe/
#gsheets #googlesheets #googlesheetstips #googlesheetstutorial #duplicates #conditionalformating #datamanagement #datacleaning
Просмотров: 321
Видео
![[NEW] Multi-Select Dropdowns in Google Sheets](http://i.ytimg.com/vi/_c7n1WO43KY/mqdefault.jpg)
![[NEW] Multi-Select Dropdowns in Google Sheets](/img/tr.png)
[NEW] Multi-Select Dropdowns in Google Sheets
Просмотров 1,3 тыс.2 месяца назад
We can finally have multi-select dropdowns in Google Sheets! In this video will look at: - how to create them, - how they work, and - three ways to use them in formulas. 📄 Text version of the guide: dataful.tech/google-sheets/multiple-selection-dropdowns/ 📨 Newsletter: dataful.tech/subscribe/ #gsheets #googlesheets #googlesheetstips #googlesheetstutorial
![The Power of Named Ranges in Google Sheets [2024]](http://i.ytimg.com/vi/btmvZuQsgjM/mqdefault.jpg)
The Power of Named Ranges in Google Sheets [2024]
Просмотров 1,9 тыс.3 месяца назад
The complete guide to Named Ranges in Google Sheets, including best practices on how to choose their name and size. Compare to the Tables - the latest Google Sheets' feature. 📨 Newsletter: dataful.tech/subscribe/ 📄 Text version of the guides: - dataful.tech/google-sheets/named-ranges/top-advantages/ - dataful.tech/google-sheets/named-ranges/best-practices/ - dataful.tech/google-sheets/named-ran...
Structured Tables in Google Sheets: Everything You Need to Know
Просмотров 8 тыс.5 месяцев назад
A deep-dive guide into the latest Google Sheets upgrade - Tables. 📄 Text version of the guide: dataful.tech/google-sheets/tables/ 📨 Newsletter: dataful.tech/subscribe/ 00:00 Intro 00:34 Three Ways to Create Tables 01:35 Five Must-Do Settings After Creating 03:40 Seven Features of Tables 10:54 Five Limitations 14:21 Conclusions and Outro Correction: 01:50 Update: Google allowed to have spaces in...
4 Ways to Sort Data in Google Sheets by Multiple Columns (2024)
Просмотров 7566 месяцев назад
Four ways to sort data by multiple columns and three things to keep in mind when doing it. 📄 Text version of the guide: dataful.tech/google-sheets/sort-by-multiple-columns/ 📨 Newsletter: dataful.tech/subscribe/ 0:00 Intro 0:20 Advanced sort 4:32 SORT function 9:09 SORTN function 11:53 QUERY function 16:19 Summary #googlesheets #gsheets #sorting #functions #googlesheetstips #googlesheetstutorial...
How to Create a Date Picker in Google Sheets (Easy)
Просмотров 3,4 тыс.7 месяцев назад
Two ways how to create a date picker (calendar dropdown) in Google Sheets. 📄 Text version of the guide: dataful.tech/google-sheets/data-validation/how-to-create-a-date-picker/ 📨 Newsletter: dataful.tech/subscribe/ #googlesheets #usability #datepicker
Nice Video❤
Is it possible to have a relative named range? For example, I have cell C13 as named range "row_id". If I reference row_id in the same row but a different column, that's fine. But if I change to a different row, I'd like the named range to reference the new row.
Sort of, not sure if it covers your use case. For example, you can name a range C1:C20 as "data". Then you can refer to it in D1 as '=data' and you will get the value from C1. Same reference in D2 will give you C2, and so on. It also works in other sheets: you will get the value from row X that is a part of a named range when referring it from row X. Note: it works only if your range has one column. You will get an error otherwise. Does it make sense to you?
@@dataful-tech Yes, thank you! That did the trick. Subbed!
Super helpful! Thanks!
This feature has made organising data collected from an online Google Form so much easier. I had used Query, but that was quite confusing for other users.
Indeed, structured tables turned out surprisingly useful in many cases. After you get used to how the look )
Thank you so much 😭😭😭✨✨ you deserve a million subscribers already!!!👏👏👏
Thank you very much! ☺
Hi, what formula should I use if I have 3 columns with multiple dropdown selections and I need to get the total number of each value from that columns. Example: The drop down list is just the same as the sample above but I need to add more column for specific dates. Dunno if I make sense but yeah
If I understood you situation correctly, you need to count how many times each unique dropdown value appears in three different multi-select dropdowns. You can do it with this formula: =LET(all_values, FLATTEN(MAP(A1:C1, LAMBDA(values, FLATTEN(SPLIT(values, ", ", false))))), QUERY(FILTER(all_values, all_values <> ""), "SELECT Col1, COUNT(Col1) GROUP BY Col1")) The formula assumes that dropdowns are in A1:C1. It will output a table with all options in one column, and number of occurrences in another. This formula can be tweaked in many ways, depending on your use case.
Updates since publishing this video (there will also be popups in the video): - Google allowed to have spaces in Tables' names. In the automatically created range names spaces will be replaced by underscores. - IMPORTRANGE now supports Table references.
Won't use the feature. But commenting to support. Keep up the good job, my Slav brother.
When im in data validation it only shows 2 types of dropdown menus, nothing else as options...
If you see only "Dropdown" and "Dropdown (from a range)" options, you are likely trying to create a date picker in a Table - they will look like in this video ruclips.net/video/AZ-PSOpx2vc/видео.html. Tables support only those two options. You can still add a date picker to that column by setting it's type to "Date".
@@dataful-tech thanks
Excellent tutorial. Thanks a lot!
Thank you for watching!
many useful info you have in your video thank you..
Happy to hear that, thank you for watching!
❤ this will save me ages
I'm definitely trying this! Thanks
great video! thanks. Please keep posting more about this.
Thanks, will do!
❤ can't wait for the next tips!
🖖
❤
Thanks for the tips!
👍
After 3rd attempt I got it but I didn't work with Google tables before
Was any specific step difficult or just unfamiliar tool in general?
@@dataful-tech 2. I think it's also a confusion from previous experience with Excel. It took time to realise different logic.
Good job!
comment) ty))
Very helpful, thanks!
Glad it was helpful!