- Видео 8
- Просмотров 7 420
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
[NEW] Multi-Select Dropdowns in Google Sheets
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
- 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
Просмотров: 297
Видео
The Power of Named Ranges in Google Sheets [2024]
Просмотров 52021 день назад
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
Просмотров 3,2 тыс.2 месяца назад
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 Since publishing the video, Google allow...
4 Ways to Sort Data in Google Sheets by Multiple Columns (2024)
Просмотров 2203 месяца назад
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)
Просмотров 1,6 тыс.4 месяца назад
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
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!