- 134
- 1 645 271
Practical Sheets
Canada
เข้าร่วมเมื่อ 21 มิ.ย. 2021
GOOGLE SHEETS - GOOGLE FORMS - GOOGLE APPS SCRIPTS - ONLY PRACTICAL PROJECTS AND TIPS - NEW VIDEOS ON WEDNESDAYS - practical.sheets@gmail.com
Enhance Google Sheets's QUERY function with Google Apps Script
In this video you'll learn how to create a writable QUERY function using Google Apps Script
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
practicalsheets.com/patreon
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
➤You can also subscribe to the channel where you´ll find a new Sheets video every week.
Here are some of the places where you can follow and support me:
➤Patreon: practicalsheets.com/patreon
➤Webpage: practicalsheets.com
➤Newsletter: practicalsheets.com/newsletter
➤Telegram: practicalsheets.com/telegram
➤Facebook: practicalsheets.com/facebook
➤Twitter: practicalsheets.com/twitter
Any suggestion, question or insights, feel free to comment below
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
practicalsheets.com/patreon
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
➤You can also subscribe to the channel where you´ll find a new Sheets video every week.
Here are some of the places where you can follow and support me:
➤Patreon: practicalsheets.com/patreon
➤Webpage: practicalsheets.com
➤Newsletter: practicalsheets.com/newsletter
➤Telegram: practicalsheets.com/telegram
➤Facebook: practicalsheets.com/facebook
➤Twitter: practicalsheets.com/twitter
Any suggestion, question or insights, feel free to comment below
มุมมอง: 254
วีดีโอ
Creating a table of contents in Google Sheets
มุมมอง 30714 วันที่ผ่านมา
In this tip, we will learn how to create a homepage or index for all of your sheets so you can easily navigate to all of your desired sheets in Google Sheets. ➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions practicalsheets.com/patreon You can also join my academy practicalsheets.com, where you´ll find, not only the templ...
Inventory Management in Google Sheets - Start with exiting inventory
มุมมอง 381หลายเดือนก่อน
In this video we will learn how to reset the inventory or start with existing inventory in our Inventory System in Google Sheets ➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions practicalsheets.com/patreon You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the vide...
Inventory System Management with Google Sheets - Part 2 - Dashboard and Tables
มุมมอง 602หลายเดือนก่อน
In this video I'll show you how to use the newly implemented tables in your inventory, and how to create a dashboard to follow the main KPIs of your inventory. ➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions practicalsheets.com/patreon You can also join my academy practicalsheets.com, where you´ll find, not only the temp...
Enhance Google Sheets: Multiple Selection Dropdowns with GAS - Part 2
มุมมอง 4242 หลายเดือนก่อน
In this video, we build upon our previous tutorial to enhance multiple selection dropdowns in Google Sheets using Google Apps Script. Learn how to apply this functionality across multiple columns and sheets, ensuring that duplicate entries are avoided and selections are dynamically updated. ➤You can find the template from this video in my patreon page, where you´ll also have priority responses ...
Advanced Alerts in Google Sheets: Customizable Pop-ups
มุมมอง 8362 หลายเดือนก่อน
Today we'll learn how to create customizable pop-ups in Google Sheets to show information and alerts to your users. Using HTML, you can modify colors, include links, adjust sizes, and more, taking your spreadsheets to the next level. ➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions practicalsheets.com/patreon You can also...
Grab values from non-blank cells only - GOOGLE SHEETS
มุมมอง 3863 หลายเดือนก่อน
In this specific request, we will use formulas and Google Apps Script to get from a row only the value in the non-blank cell. In other words, remove the blank cells ➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions practicalsheets.com/patreon You can also join my academy practicalsheets.com, where you´ll find, not only the...
Journal Entries App with AppSheet - Introduction to AppSheet
มุมมอง 3853 หลายเดือนก่อน
In this tip, we will learn how to create a Journal Entry App with AppSheet. This will serve as a n introduction of sorts to AppSheet, its capabilities, advantages and disadvantages ➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions practicalsheets.com/patreon You can also join my academy practicalsheets.com, where you´ll fi...
Advanced Number Sequence by Categories in Google Sheets
มุมมอง 4113 หลายเดือนก่อน
In this video you'll learn how to create a number sequence in Google Sheets that takes into account a category from a specified column, using advanced Formulas ➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions practicalsheets.com/patreon You can also join my academy practicalsheets.com, where you´ll find, not only the temp...
Create a Dependent Dropdown Form for Google Sheets - Webapp
มุมมอง 7364 หลายเดือนก่อน
In this video, we will learn how to create a form webapp with two dropdown options, the second one dinamically changing based on the option selected in the first one. ➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions practicalsheets.com/patreon You can also join my academy practicalsheets.com, where you´ll find, not only t...
Insert data easily to Google Sheets with an autocomplete Form (Webapp Tutorial)
มุมมอง 6884 หลายเดือนก่อน
In this tip, we will learn how to create an autocomplete form with a webapp in Google Sheets ➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions practicalsheets.com/patreon You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, ...
Dependent dropdown with multiple selection in Google Sheets
มุมมอง 1.6K5 หลายเดือนก่อน
In this tip, we will learn how to create dependent dropdowns with Google Apps Script. Nothing new, right? But this time, you may select multiple items! ➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions practicalsheets.com/patreon You can also join my academy practicalsheets.com, where you´ll find, not only the templates fo...
How to order dropdowns in Google Sheets
มุมมอง 2.2K5 หลายเดือนก่อน
In this tip, we will learn several ways in which to order dropdowns in Google Sheets ➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions practicalsheets.com/patreon You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technica...
Create a Scheduling Webapp 📅 with Google SHEETS and Google APPS Script
มุมมอง 1.2K6 หลายเดือนก่อน
In this project, we will create an HTML form that allows users to pick a date and a Course to RSVP. Everything will be created inside Google Sheets ➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions practicalsheets.com/patreon You can also join my academy practicalsheets.com, where you´ll find, not only the templates for th...
How to automatically Import CSV with a script in Google Sheets
มุมมอง 3.6K7 หลายเดือนก่อน
In this tip, you will learn how to automatically import CSVs from your Google Drive into your Google Sheet every day or every week ➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions practicalsheets.com/patreon You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the vi...
Inventory WebApp with Google Sheets and Google Apps Script - Part 2 - Create a Product Dropdown
มุมมอง 3K7 หลายเดือนก่อน
Inventory WebApp with Google Sheets and Google Apps Script - Part 2 - Create a Product Dropdown
How to edit Google Form responses directly from GOOGLE SHEETS
มุมมอง 14K7 หลายเดือนก่อน
How to edit Google Form responses directly from GOOGLE SHEETS
Inventory Management System in Google Sheets - 2024 Edition
มุมมอง 24K8 หลายเดือนก่อน
Inventory Management System in Google Sheets - 2024 Edition
Inventory WebApp with Google Apps Script and Google Sheets
มุมมอง 10K8 หลายเดือนก่อน
Inventory WebApp with Google Apps Script and Google Sheets
Multiple Selection Dropdown with Google Sheets and Google Apps Script - 2024
มุมมอง 25K9 หลายเดือนก่อน
Multiple Selection Dropdown with Google Sheets and Google Apps Script - 2024
Protecting your Google Sheets with Password - Part 2
มุมมอง 9599 หลายเดือนก่อน
Protecting your Google Sheets with Password - Part 2
Timestamp in multiple sheets in Google Sheets
มุมมอง 80810 หลายเดือนก่อน
Timestamp in multiple sheets in Google Sheets
2 ways to create a Dropdown from another File in Google Sheets
มุมมอง 7K10 หลายเดือนก่อน
2 ways to create a Dropdown from another File in Google Sheets
Create better suggestions / autocomplete functionality in Google Sheets
มุมมอง 2.4K10 หลายเดือนก่อน
Create better suggestions / autocomplete functionality in Google Sheets
Create a pop-up alert in Google Sheets
มุมมอง 12K11 หลายเดือนก่อน
Create a pop-up alert in Google Sheets
Categorize Google FORMS responses in different sheets in Google SHEETS
มุมมอง 19K11 หลายเดือนก่อน
Categorize Google FORMS responses in different sheets in Google SHEETS
Generate consecutive numbers for Google Forms Responses in Google Sheets
มุมมอง 7K11 หลายเดือนก่อน
Generate consecutive numbers for Google Forms Responses in Google Sheets
How to create flexible subscription forms easily with Prefilled Forms in Google Forms
มุมมอง 42711 หลายเดือนก่อน
How to create flexible subscription forms easily with Prefilled Forms in Google Forms
7 ways to drag down your formulas in Google Sheets
มุมมอง 6Kปีที่แล้ว
7 ways to drag down your formulas in Google Sheets