Better Sheets on YouTube

How To Combine Link and Text

Learn how to efficiently combine links and text in Google Sheets using the hyperlink formula, allowing you to create organized and clickable references effortlessly.

MESSIEST SPREADSHEET MISTAKE

Discover the most common mistake made in spreadsheets that leads to messy data and learn how to fix it using data validation techniques. This video will guide you through the process of implementing effective data validation to keep your spreadsheets organized and accurate.

How To Automatically Add Dates in Google Sheets

Learn how to automatically add timestamps and dates in Google Sheets using App Script. This video covers both automatic date entry on sales input and creating a custom menu for manual date insertion.

How to Email Editors and/or Viewers Google Sheets

Learn how to easily email collaborators directly from Google Sheets, allowing you to share your work with editors and viewers effortlessly.

Track Last Contact in Google sheets

Learn how to efficiently track your last contact with clients in Google Sheets by creating a streamlined contact log with dropdowns and formulas for easy data management.

How To Get Last Word in Cell

Learn how to extract the last word from a cell in Google Sheets using a simple formula that handles multiple names effectively.

Use VLOOKUP to Add Flag to Google Sheets

Learn how to use VLOOKUP in Google Sheets to dynamically add country flags using ISO codes and an API. This tutorial provides step-by-step instructions for creating a visually appealing flag display in your spreadsheets.

How To Sum By Client

Learn how to efficiently sum hours worked and paid by client using the SUMIFS function in Google Sheets, along with tips for creating a clear summary table.

Remove Extra Spaces

Learn how to efficiently remove extra spaces in your Google Sheets using regular expressions and simple formulas. This video provides step-by-step guidance on cleaning up your data for better presentation.

Capitalize First Letter

Learn how to capitalize the first letter of each word in Google Sheets using the 'PROPER' function, and discover a simple trick to apply it to an entire column with ARRAYFORMULA.

How To Insert Row Under Header Automatically

Learn how to automatically insert a row below the header in Google Sheets using App Script. This video guides you through the process of creating a custom menu and setting up triggers for automation.

CLUTTERED CODE

In this video, learn how to declutter your code and improve readability using Apps Script and AI tools like ChatGPT. Discover practical tips for managing your Gmail and enhancing your coding efficiency.

Highlight If Larger than Other Column

Learn how to use conditional formatting in Google Sheets to highlight cells in one column based on their values compared to another column, perfect for tracking overtime hours.

RED if Negative, GREEN if Positive

Learn how to use conditional formatting in Google Sheets to visually differentiate between positive and negative hours worked. This tutorial shows you how to set up rules that turn negative values red and positive values green.

Replace Numbers with Asterisks

Learn how to replace numbers with asterisks in Google Sheets using regular expressions. This tutorial covers the REPLACE function and how to apply it across an entire column effortlessly.

Remove Non Numbers

Learn how to remove non-numeric characters from your data using the regexreplace function in Google Sheets. This video guides you through the process of cleaning up your data for better usability.

Google Sheets Count Cells with Text

Learn how to effectively count cells with text in Google Sheets using functions like COUNTA, COUNTIF, and COUNTBLANK. This video covers various scenarios, including counting specific text and handling numbers.

How to Lock Multiple Tabs at Start of Sheets List in Google Sheets

Learn how to lock multiple tabs in Google Sheets using Apps Script, allowing for better organization and automation of your spreadsheet workflow.

How to Checkbox if Date This Year in Google Sheets

Learn how to efficiently use checkboxes in Google Sheets to automatically check off dates that fall within the current year or the past year. This video provides a simple formula to streamline your data management.

Copy Date to Next Cell Automatically

Learn how to automatically copy a date from one cell to another in Google Sheets using Apps Script. This tutorial covers creating a script that triggers daily to streamline your appointment tracking.

Find Duplicates in Other Column

Learn how to efficiently find duplicates between two columns in Google Sheets using conditional formatting and the MATCH function. This tutorial simplifies the process of verifying attendance against registration lists.

Select Random From List in Google Sheets

Learn how to randomly select a winner from a list in Google Sheets using the RANDBETWEEN function and other formulas. This tutorial walks you through the process step-by-step, ensuring you can automate your selection without manual counting.

Sales Tracker

Learn how to effectively track sales for your team using Google Sheets with functions like SUMIFS and COUNTIF. This video provides a step-by-step guide to creating a sales tracker dashboard that highlights performance metrics.

Get YouTube Subscriber Count

Learn how to retrieve the subscriber count from any YouTube channel URL using Google Sheets and the YouTube API in this step-by-step tutorial.