Use Index Match the RIGHT way (Google Sheets) Sheets Ninja 2026-09-17 | Use Index Match the RIGHT way (Google Sheets)
Highlight Duplicates in Google Sheets (Mobile App) #googlesheets #mobileapp Sheets Ninja 2025-10-03 | Learn how to highlight duplicates in the Sheets mobile app.
Create a Fill Chart (Google Sheets) Sheets Ninja 2025-10-02 | Learn how to create clean, simple fill charts in Google Sheets in this step-by-step tutorial.
Add Dropdowns in Google Sheets (Mobile App) #googlesheets #mobileapp Sheets Ninja 2025-10-01 | Today, you'll learn how to add dropdowns in the mobile app.
Restrict Number of Google Form Responses Sheets Ninja 2025-10-01 | In today's video, you'll learn how to limit the number of responses on a Google Form with a simple script.
📅 Google Calendar Appointment Scheduler Sheets Ninja 2025-09-30 | Ever wish appointment or meeting scheduling was as easy as sending or sharing a link? In today's video, I'll show you how to setup the Appointment Schedule in Google Calendar, which allows you to do just that.
Conditional Question Routing in Google Form Sheets Ninja 2025-09-25 | Do you need to be able to route users through a Google Form based on the answers they select? In this video, I'll walk you through how to set this up and how to structure it.
📈 Creating Looker Studio Dashboard from Google Sheets Sheets Ninja 2025-09-23 | Do you need to take Google Sheets data and make a Looker Studio dashboard report from that data? In this quick tutorial, you'll learn the basics of how to add filters, how to add and modify charts, and utilize multiple pages in a Looker Studio report.
Convert Existing Data to Multi Select Dropdown Sheets Ninja 2025-09-19 | Do you have data that you want to convert into a multi-select dropdown, but having trouble making it happen? In this video, you'll learn several ways to convert your data, including how to merge several columns.
Create Stacked Charts (Google Sheets) Sheets Ninja 2025-09-18 | Learn how to create stacked bar or column charts in Google Sheets in this step-by-step tutorial, including how to set up the data for the chart.
Vibe Coding Sentiment Analysis in Google Sheets Sheets Ninja 2025-09-17 | Do you need to do sentiment analysis and either can't or don't want to use AI to process your text? In today's video, we're going to vibe code a sentiment analysis script that you can use directly in your Google Sheets that relies only on hard-coded sentiment analysis libraries (included in the sample file below).If you want to process your text with ChatGPT, check out this other video I did on using ChatGPT to run sentiment analysis on your data: youtu.be/rmr6IyaIr3wYou can make a copy of the final Google Sheet & script here: bit.ly/460IQuw
ChatGPT Sentiment Analysis in Google Sheets Sheets Ninja 2025-09-16 | Do you need to run AI sentiment analysis on text in Google Sheets? In this video, I'll show you how to write a simple script that will take your text and run it through ChatGPT to generate sentiment analysis.*You will need a OpenAI API key to do this*1. Go to openai.com2. Log in to the "API Platform"3. Click on "Dashboard" on the top right4. Click on "API keys" on the left and generate a key (copy it into the script)5. Now click on the gear icon on the top right.6. Click "Billing" and add a little credit to your account so you can run requests
🗺️ Get Time and Distance Between Two Addresses in Google Sheets Sheets Ninja 2025-09-11 | Today, you'll learn how to easily calculate time & distances between two addresses in Google Sheets with a custom function.You can make a copy of the Google Sheet with the custom function here: bit.ly/4fSHhlG
IF Formula (simple, and/or, nested) Tutorial in Google Sheets Sheets Ninja 2025-09-10 | Learn how to use the IF function in Google Sheets, from the simplest IF statement, how to incorporate AND / OR, how to nest IF statements, and even some smart ways to make complex IF formulas simpler.
Merge Data from Tabs into One Main Tab (Google Sheets) Sheets Ninja 2025-09-09 | In this video, you'll learn several ways to combine data from multiple sheets or tabs in Google Sheets into one tab, along with the drawbacks and benefits of each so you can easily determine which method will work for you. 0:00 1. Initial Setup0:25 2. Simple Array Literal { } method2:33 3. Simple QUERY Method3:32 4. Checking multiple columns for blanks4:24 5. QUERY: The Mixed Data Problem5:21 6. FILTER Method6:18 7. FILTER: The Blank Tab Problem7:02 8. FILTER: Fixing The Blank Tab Problem9:50 9. Simple Method: Add Tab Name to the Data12:35 10. Add Tab Name w/o Helper Column17:25 11. Conclusion
🥷 Master Google Sheets: Beginners Fast Track Sheets Ninja 2025-09-08 | Welcome to Google Sheets! This video is a comprehensive beginner's course to Google Sheets, starting at the very beginning.When you're ready to move on, check out the many other tutorials we have on our channel. A good place to start is our basic guides covering some common formulas: youtube.com/playlist?list=PL8N8dF6K6B3NykPuAe9zS_iUhVPhvZtKw0:00 Welcome0:13 Creating a Google Sheets Spreadsheet0:32 Create from a Template1:00 Basic Google Sheet Management (Delete, Renaming, Move to Folder)2:33 Overview of Menus5:42 Toolbar6:10 How to Share / Manage Access7:03 Tab/Sheet Overview7:48 Tab / Sheet Protection9:05 Move / Hide / Show Tabs9:37 Rows & Columns (Freezing, Resizing & Insert/Delete)11:09 Entering Data & Using Auto-Fill to Save Time12:55 Formatting Data (adding background and font colors, alternating rows)15:20 Number Format (Currency, Dates, etc.)16:29 Links - How to Add17:01 Find & Replace17:43 Checkboxes18:05 Dropdowns19:29 Dates and Date Picker20:43 First formulas - cell references & math23:23 Percentages24:13 Don't Mix Numbers & Text25:15 Moving a data table25:52 Copy/Paste a Data Table26:56 Inserting / Deleting Columns / Rows28:09 Hide Gridlines28:17 Adding Borders29:55 Adding Data Table Title/Header31:13 Intro to Formulas - Subtotals34:39 Sparklines35:16 Charts37:44 Paint Format38:33 Monthly Growth Rate formula39:18 Adding Metrics/Stats Section40:36 Named Ranges42:19 Filter Tool44:11 Quick Stats44:42 Column Stats44:53 Comments46:05 Notes46:57 Version History48:35 Google Form50:30 Tying Form Responses into Data Table52:05 Sumifs55:58 Updating Google Form to Sales Entry58:55 Creating Expenses Table1:00:44 Creating Sales Table1:01:18 Setting Column Types on a Table1:02:32 Filling in Sales Summary from Tables1:04:29 Creating Pivot Tables & Charts1:08:36 Conclusion
👨💻 7 Simple Google Sheet Scripts To Make Your Life Easier Sheets Ninja 2025-09-04 | If you would like to dip your toe into scripts in Google Sheets, this is the video for you! I'm going to take you step-by-step through not one, but 7 different scripts to help you save time, effort, and start automating your Google Sheets. None of these scripts require authorization, so they will automatically work for everyone using the spreadsheet without having to jump through any authorization hoops. Let me know in the comments below if you've come up with any other neat use cases for scripts that don't require authorization!If you want to download a copy of the Google Sheet with ALL the scripts intact (each set up to work on a single tab), you can do that here: bit.ly/3FCWN6Y***** TIMESTAMPS *****0:00 Intro1:35 Script Basics6:14 1. Adding Last Edited/Updated Timestamps12:21 2. Adding Note to a Cell with Last Edit Details18:35 3. Hide or Delete a Row22:20 4. Insert a New Row at the Top of the Sheet24:07 5. Add Price or Text Based on Dropdown Selection28:02 6. Dependent Dropdowns33:24 7. Clearing a Form or Fields
🔍︎ Find Matches Between Two Google Sheets Sheets Ninja 2025-09-04 | Do you need to find matches between two different Google Sheets? In this video, I'll show you how to compare data in two different Google Sheets and show matching data OR not matching data if you want to find data that doesn't have a match.VLOOKUP Tutorial: youtu.be/pPO4WRRo9fQ
✅ Dynamic Chart with Checkboxes for an Awesome Dashboard (Google Sheets) Sheets Ninja 2025-09-03 | Every wonder how to dynamically determine what columns show up in a chart based on a checkbox? Look no further than this quick tutorial that takes you through, step-by-step from raw data to a slick, streamlined chart.You can download a copy of the final Google Sheet here: bit.ly/41yyCyz
Email Approval Workflow with Google Forms & Google Sheets Sheets Ninja 2025-09-02 | In this video, I'll show you how to create an email approval workflow, using an expense reimbursement request as an example. The user would use a Google Form to submit an request, the approver would get an email with the details and the option to approve or deny the request, which then triggers a follow-up email to the requestor as well as moving that row in the sheet to the appropriate section (Approved to payout or Denied).You can make a copy of the final Google Sheet, Form, and Apps Script here: bit.ly/41J4eBR***** TIMESTAMPS *****0:00 Intro0:13 1. Creating the Google Form2:42 2. Setting up the Google Sheet4:58 3. Scripting the Approval Request Email18:54 4. Script to Handle Approved/Denied Status30:25 5. Authorization, Trigger, and Web App Setup33:15 6. Running the Workflow34:54 7. Updates & Tweaking HTML43:21 8. Conclusion
Turn Google Sheets Data into a Dynamic HTML Dashboard Web App (Vibe Coding) Sheets Ninja 2025-08-28 | In this video, I'll show you how to vibe code in Google Apps Script using ChatGPT to take Google Sheets data and turn it into a sleek dashboard that you can embed in a Google Site for easy sharing. Check it out to see how to make a cool dashboard and then try this out for yourself!You can download the final Google Sheet & Apps Script here: bit.ly/46cxWAL
📄 One Click to Save or Email PDF From Google Sheet Sheets Ninja 2025-08-27 | In this video, we'll look at how to create a PDF from Google Sheets using Apps Script to save it to Google Drive, email it, or both.You can watch my tutorial on how to create the invoice template here: youtube.com/watch?v=-pvhUw5RbNE
Conditional Formatting Based on Another Cell (Google Sheets) Sheets Ninja 2025-08-26 | Learn how to conditionally format a column or entire row based on the value in another cell, whether it's in the same row or another cell where you select an option or enter a value to compare.
● Bullet Points in Google Sheets Sheets Ninja 2025-08-25 | Here's how to add bullet points in Google Sheets. Bonus, you can use this method for any HTML symbol.Some helpful websites for finding HTML symbols:toptal.com/designers/htmlarrowshtmlsymbols.net/#google_vignette w3schools.com/charsets/ref_html_symbols.asp
YouTube Thumbnails in Google Sheets Sheets Ninja 2025-08-25 | Every want to pull YouTube thumbnails automatically into Google Sheets with just the link? Even better, making that thumbnail a link? In this video, I'll walk you through how to do just that.***** FORMULAS *****Regex Formula: REGEXEXTRACT(D4,"=(.*)")Image Format: img.youtube.com/vi/VIDEO_ID/mqdefault.jpgImage: =image("img.youtube.com/vi/"®EXEXTRACT(D5,"=(.*)")&"/mqdefault.jpg")Hyperlink: =hyperlink(D5,image("img.youtube.com/vi/"®EXEXTRACT(D5,"=(.*)")&"/mqdefault.jpg"))
🗓 Highlight Past Dates (Google Sheets) Sheets Ninja 2025-08-22 | In this video, we'll walk through several methods of highlighting past dates, as well as future date, and finally, how to stack multiple conditional highlighting rules to make sure they get applied correctly.
💡 7 Learning Hacks Your Brain Actually Wants You to Know Sheets Ninja 2025-08-21 | To celebrate 300 videos on our channel, I'm taking a step back from our regular Google Sheets educational videos to take a look at how to get better at learning (whether it's Google Sheets, Apps Script, or anything else you want to learn).If you want to watch that infamous Google Sheets Filter tool video, you can do so here: youtu.be/ANLwUJDtsAE0:00 Intro2:15 1. Start Small5:30 2. Focus on What You'll Use8:15 3. A Little Stress is Good13:17 4. Celebrate Wins15:07 5. Activate Creativity19:55 6. Learning is Contagious21:52 7. Teach Others23:59 Conclusion
5 Minute Gantt Chart (Google Sheets) Sheets Ninja 2025-08-20 | Let's create a simple Gantt Chart in under 5 minutes!If you want to take it to the next level, check out my full tutorial that includes a full year of dates and a different color for the start and end dates: youtu.be/0okPmZzPdN8
🗓️ Filter Data by Month (Google Sheets) Sheets Ninja 2025-08-19 | Do you ever need to filter data by month but find the built-in filter tools confusing to use? In this video, I show you how to build a quick filter using a month dropdown, how to add a year dropdown, or even other dropdowns if needed.
🌱 Growing Plant Progress Chart (Google Sheets) Sheets Ninja 2025-08-18 | Ever wish you could using a growing plant or other images representing growth as a progress symbol / chart in Google Sheets? In today's video, I'll show you an example of how to build this using growing plant images, but you can substitute your own images for your own purposes! Let me know what you images you use in the comments below!You can make a copy of the final Google Sheet here: bit.ly/47tw8W7
How to Decide Between Comments & Notes (Google Sheets) Sheets Ninja 2025-08-16 | Learn how to use comments & notes in Google Sheets along with the best time to use each!
🗑️ Delete Multiple Rows or Columns (Google Sheets) Sheets Ninja 2025-08-16 | Learn how to delete multiple rows and/or columns in Google Sheets in a variety of ways.
AI Coding Autocomplete in Google Apps Script (Windsurf) Sheets Ninja 2025-08-15 | Tired of typing out every single line in your Apps Script projects? Stop the madness and start using the free Windsurf chrome extension that gives you AI autocomplete suggestions. In this video, I walk you through how to set it up so it will work on all your Google App Script projects.***** LINKS *****Windsurf: windsurf.comChrome extension: chromewebstore.google.com/detail/hobjkcpmjhlegmobgonaagepfckjkceh***** ALLOWLIST CODE *****Here's the piece of code to add in the Options section under "ALLOWLIST" if it's missing:https:\/\/(.*\.)?script\.google\.com(\/.*)?
🏆 Create a Leaderboard in Google Sheets Sheets Ninja 2025-08-15 | In today's video, we'll create a very simple leaderboard in Google Sheet.
⛶ Easy QR Codes in Google Sheets Sheets Ninja 2025-08-14 | In this video, I'll show you how to quickly and easily generate QR codes in Google Sheets using a formula.You can make a copy of the Google Sheet here: bit.ly/4cWo3bq
📋 Daily Task To-Do List Decision Matrix Sheets Ninja 2025-08-14 | Ever heard of the Eisenhower task priority matrix? It's a way of quickly prioritizing tasks on your to-do list. In today's video, I'm going to talk you through building a quick task decision matrix to evaluate and prioritize your to-do list.You can make a copy of the final Google Sheet here: bit.ly/3IUIXP7
Pull Data from Another Sheet Based on Criteria (Google Sheets) Sheets Ninja 2025-08-13 | Ever need to pull specific data from one Google Sheet to another? In this tutorial, I'll walk you through step-by-step of first connecting one Google Sheet to another, adding a simple fixed criteria, and finally adding multiple dropdown conditions.
✅ Easy Dynamic Task Progress Bar (Google Sheets) Sheets Ninja 2025-08-13 | Are you ready for a quick & easy progress bar for each of your tasks or projects in Google Sheets? I'll walk you through how to set this up for each row as well as adding an overall progress bar.
Add or Subtract Day, Workday, Week, Month, or Year from a Date (Google Sheets) Sheets Ninja 2025-08-12 | Ever wonder how to add or subtract one or more days, workdays, weeks, months, or years from a date in Google Sheets? I'll walk you through each of those scenarios in this sheet.
Internal Order Form from Google Sheets Data (Vibe Coding Web App) Sheets Ninja 2025-08-12 | Do you need an internal order form for your organization? In today's video, we're going to use ChatGPT to vibe code an order form that will take dropdowns from a Google Sheet, populate a HTML order form, and then take the submitted data and add it to a tab on the Google Sheet.You can make a copy of the final Google Sheet & Script here: bit.ly/469ymYj***** SAMPLE AI PROMPT *****Build a Google Apps Script HTML web app that acts as an order form, backed by a Google Sheet with three tabs:1. "ORDER - LINE ITEMS" (columns: Order Date, Order #, Product, Qty, Location)2. "INVENTORY" (columns: Out of Stock, SKU, Category, Product Name, Image Link, Description)3. "LOCATIONS" (columns: Location, Street Address, City, State, Zip, Email, Phone)The app should:* Frontend Design (HTML + Bootstrap):* Use Bootstrap 5 for styling.* Form container should have a medium gray background (#dee2e6), padding, and soft box-shadow.* Include a Location dropdown at the top.* Display a dynamic table with 5 default line item rows. Each row should include:* Category dropdown (populated from INVENTORY)* Dependent Product dropdown with thumbnail image and tooltip on hover (image + description)* Quantity field (blank by default, placeholder “Enter Qty”)* Delete button with a trash can icon (Bootstrap Icons)* Allow adding more line items with a "+ Add Item" button.Form Behavior:* Auto-focus the qty input when a row is added.* Validate qty input only if a product has been selected. If qty is missing or invalid, highlight with red border (is-invalid).* Prevent form submission if any selected product is missing a valid qty.* Prevent removing the last remaining row.Submission Logic:1. On submission:A. Show a Bootstrap spinner while submitting.B. Save order to "ORDER - LINE ITEMS" tab with:* Current date* Auto-generated sequential order number* Product name, qty, and locationC. Show a Bootstrap modal with order number confirmation.D. After modal closes, reset the form back to 5 empty rows.Apps Script Backend (Code.gs):1. doGet() to return the Index.html2. getFormData() to return categories, product info, and locations3. generateOrderNumber() to increment order number based on last row4. submitOrder(orderData) to write each line item to the sheet.
Autofill or Copy Formulas Down in Google Sheets Mobile App Sheets Ninja 2025-08-08 | Ever wonder how to autofill or copy formulas down in the Sheets mobile app? It's easier than you think!
👀 VLOOKUP Return Results from the LEFT (Google Sheets) Sheets Ninja 2025-08-07 | VLOOKUP normally searches the left-most column for the lookup value and returns a column to the right. But what if you need to return a column to the left of the lookup column?In this video, I'll walk you through the solution along with a few extra tips, like how to return more than one column, and columns both to the left AND right of the lookup column.
Update Google Forms Dropdown from Google Sheets Sheets Ninja 2025-08-07 | Ever wished you could update dropdowns on a Google Form from a Google Sheet? In this video, I'll walk you how to write a script to accomplish just that, how to run the script from a menu on the Google Sheet, or even how to make the script run automatically--either when the Google Form is submitted or on a schedule.
Copy Google Form + Google Sheet Sheets Ninja 2025-08-06 | Do you ever need to make a copy of a linked Google Sheet and Google Form(s)? In this video, I'll walk you through several scenarios and what you need to do in each scenario.
HTML Display for Google Sheets Data (Vibe Coding Web App) Sheets Ninja 2025-08-05 | Today, we're using ChatGPT to vibe code a HTML display for Google Sheets data. If you ever wanted to make a slick, streamlined display from your boring Google Sheets data, look no further than this video!You can make a copy of the final Google Sheet + Script here: bit.ly/4peI84m
How to Publish a Google Form Sheets Ninja 2025-07-31 | Google updated Forms from "Send" to "Publish." In this video, I'll walk you through how to use the new layout.
How to Add Placeholders in Google Sheets Tables Sheets Ninja 2025-07-30 | Ever wonder how to add placeholders in a Google Sheets Table? In this video, I'll walk you through the different types of placeholders and how to switch and modify them.
🧮 Count or Sum Cells By Color (Google Sheets) Sheets Ninja 2025-07-28 | Do you need to count or sum cells based on the background color? In this video, I'll show you two custom functions that allow you to do just this in Google Sheets, along with a quick secret to make this easily refreshable.You can make a copy of the Google Sheet that includes both custom functions here: bit.ly/3H2fj9Y
Highlight Entire Row (Google Sheets Mobile App) #googlesheets #conditionalformatting Sheets Ninja 2025-07-25 | Do you need to conditionally format an entire row in Google Sheets? Let's walk through how to add these formatting rules using the Sheets mobile app.
🧮 Count Cells Containing Specific Text (Google Sheets) Sheets Ninja 2025-07-24 | Do you need to count cells that match text or contain text? In this video, I'll show you how to use the countif formula to do just that.
