Better Sheets on YouTube

How to Automatically Add Numbers When There is Data, Not Zeros, in Google Sheets

Learn how to automatically sum numbers in Google Sheets while ignoring zeros, keeping your inventory data clean and concise.

Copy Paste Data Validation to Other Spreadsheet File in Google Sheets

Learn how to effectively copy and paste data validation rules from one Google Sheets file to another, overcoming common errors and ensuring your dropdowns work seamlessly across spreadsheets.

How To Count Checkboxes In Google Sheets

Learn how to effectively count checkboxes in Google Sheets using the COUNTIF and SUM functions, and discover a fun way to customize checkbox values.

How To Highlight Any Date One Week In Future

Learn how to highlight dates in Google Sheets that fall between 7 and 14 days in the future using conditional formatting. This tutorial provides step-by-step instructions to customize your date highlighting effectively.

How To Format Sheets for Notes and Sort By Group

Learn how to effectively format your Google Sheets for notes and sort data by groups using built-in features and custom app scripts.

How to Track Days Since Task Started in Google Sheets

Learn how to track the days since a task started in Google Sheets by automating date entries and calculating the difference using formulas and Google Apps Script.

How to Find and Replace Only Two Letters in Google Sheets

Learn how to effectively find and replace specific letters in Google Sheets, ensuring accuracy by matching entire cell contents. This tutorial covers the steps to replace initials like 'QA' with their full form, 'quality assurance'.

How To Find and Replace Text in Google Sheets

Learn how to efficiently find and replace text in Google Sheets, ensuring consistent formatting across your data. This tutorial covers the use of the find and replace menu, case matching, and searching within specific ranges.

How to do Exponents in Google Sheets

Learn how to perform exponentiation in Google Sheets using simple multiplication, the caret symbol, and the POWER function for more flexibility and ease. This video provides practical examples to enhance your spreadsheet skills.

How to Search Tab Names in Google Sheets

Learn how to efficiently search for tab names in Google Sheets using a simple app script, making it easier to navigate through numerous tabs in your spreadsheet.

How to Hide Cell Values Based on Checkbox or Dropdown

Learn how to hide cell values in Google Sheets using checkboxes or dropdowns based on specific criteria, enhancing your spreadsheet's functionality and user experience.

How to Enter New Line in Google Sheets

Learn how to easily insert new lines within a cell in Google Sheets, enhancing your note-taking and text organization without relying solely on text wrapping.

How to Insert Timestamp in Google Sheets

Learn how to insert timestamps in Google Sheets to track when tasks are completed, using both simple date entries and more complex timestamp functions with Google Apps Script.

Make Your Google Sheet A Template For Others To Copy

Learn how to turn your Google Sheet into a template that others can easily copy by adjusting the sharing settings and modifying the link. This video provides a step-by-step guide to streamline the process for users.

How To Download All Tabs as CSV in a Zip File

Learn how to download all tabs from a Google Sheet as CSV files in a zip file using Google Apps Script. This tutorial provides a simple solution to streamline the process and save time.

How To Divide in Google Sheets

Learn how to divide numbers in Google Sheets using various methods, including the divide formula and referencing cells for dynamic calculations.

How do I add multiple links in a Google sheet cell?

Learn how to add multiple hyperlinks within a single cell in Google Sheets, making your data more interactive and organized. This tutorial covers the steps to insert and remove links efficiently.

How To Fill Down Formulas

Learn how to efficiently fill down formulas in Google Sheets using quick methods like double-clicking the fill handle or using the Command D shortcut. This video provides practical tips to save time when working with large datasets.

YOU CAN DO BETTER

Learn how to enhance your spreadsheets with simple design tips, including font selection and custom colors, to make them visually appealing and more effective.

How to Filter View by Month for Dashboards in Google Sheets

Learn how to create a filter view by month in Google Sheets, allowing you to easily analyze data for specific months using VLOOKUP and dropdown menus.

How To Filter by Date in Google Sheets

Learn how to effectively filter data by date in Google Sheets, creating a dynamic dashboard that allows you to view specific date ranges with ease.

How to Clear Formatting Automatically in Google Sheets

Learn how to automatically clear formatting in Google Sheets every day, ensuring a fresh start with default settings. This tutorial guides you through creating a script and setting up triggers for seamless automation.

List Every File In Your Google Drive

Learn how to programmatically log every file in your Google Drive using Google Sheets and Apps Script. This tutorial walks you through creating a function that retrieves file names and IDs efficiently.

How to Create a Google Folder in Folder in a Google Drive in Apps Script

Learn how to create nested folders in Google Drive using Google Apps Script, directly from your Google Sheets. This tutorial walks you through the process of automating folder creation with dynamic names sourced from your spreadsheet.