Spreadsheet fundamentals

Create an Automated Extended Weekly Calendar View in Google Sheets

Learn how to create an automated extended weekly calendar view in Google Sheets that updates dynamically to show multiple weeks ahead. This tutorial builds on previous methods to enhance your calendar functionality effortlessly.

Make a Tour of the Sheet

Learn how to create an interactive tour of your Google Sheets tabs using App Script, making it easier for users to navigate and understand your spreadsheet's layout and functionality.

Create a Household Chores Board in Google Sheets

Learn how to create a household chores board in Google Sheets that visually organizes tasks by person, similar to a Kanban board. This tutorial shows you how to filter chores and create checklists for easy management.

How To Color Code Drop Down List for Whole Row in Google Sheets

Learn how to color code drop down lists in Google Sheets to enhance your data visualization. This tutorial covers step-by-step instructions for applying color coding to entire rows based on drop down selections.

How To Calculate Average Workout Time Per Weekday

Learn how to calculate the average workout time per weekday using Google Sheets, including tips on using the AVERAGEIF function and managing your data effectively.

How to Create a Sequential ID when Google Form Submitted to Google Sheets

Learn how to create a sequential ID for Google Form submissions in Google Sheets using Google Apps Script. This tutorial covers both methods: using a dedicated sheet and utilizing document properties.

Conditional Formatting With Checkboxes in Google Sheets

Learn how to use checkboxes for conditional formatting in Google Sheets to visually manage your tasks. This tutorial covers setting up checkboxes, applying custom formatting, and enhancing your checklist functionality.

Number Rows If Blank Rows in Google Sheets

Learn how to effectively number rows in Google Sheets, even when there are blank rows, using simple formulas and tricks.

How to Set 1 Hour Expiration to Share Google Sheets

Learn how to set a one-hour expiration for sharing Google Sheets, ensuring that your data is only accessible for a limited time. This quick tutorial walks you through the steps to manage access effectively.

How To Grey Out Unused Cells

Learn how to effectively gray out unused or blank cells in Google Sheets using conditional formatting techniques. This video provides step-by-step instructions to enhance your spreadsheet's visual clarity.

Spreadsheet's Birthday

Discover how to create a fun automation in Google Sheets that celebrates your spreadsheet's birthday with a toast! This video guides you through building a function using Apps Script to determine when your spreadsheet was created and notify you on its birthday.

Show More Decimal Places Each Day in Google Sheets

Learn how to automate the process of increasing decimal places in Google Sheets daily with this fun tutorial from Sheet Fools. Discover how to use Google Apps Script to create a trigger that enhances your spreadsheet's appearance without altering the underlying data.

Text Tilts 1 degree every day

In this video, learn how to create a fun automation in Google Sheets that tilts your header text by one degree every day, adding a playful twist to your spreadsheets. Follow along as we set up the script and triggers to automate this quirky feature.

How to Delete Every Blank Row

Learn how to efficiently delete every blank row in Google Sheets using Google Apps Script. This tutorial guides you through the process step-by-step, ensuring you can automate row deletion effectively.

How Many Days Until 4th of July

Learn how to create an automatic countdown to the 4th of July using Google Sheets formulas. This tutorial demonstrates how to handle date differences and errors effectively.

How to Convert Student Names to Emails

Learn how to convert student names into email addresses using Google Sheets by substituting spaces with either nothing or dots. This tutorial covers the use of the SUBSTITUTE function and ARRAYFORMULA for efficient email generation.

How to Change Font in Google Sheets

Learn how to change fonts in Google Sheets, including selecting from default options and adding new fonts. This video also covers conditional formatting to enhance your spreadsheet's appearance.

Add a Button To Automate Add a Row with Date

Learn how to create a button in Google Sheets that automatically adds a new row with the current date, streamlining your data entry process.

How to Delete Every Checked Row

Learn how to quickly delete every checked row in Google Sheets using App Script with a simple function. This tutorial walks you through the process step-by-step, ensuring you can automate your spreadsheet tasks efficiently.

How to Reverse First and Last Name and Add Comma Between in Google Sheets

Learn how to reverse first and last names in Google Sheets using a simple formula that adds a comma between them. This tutorial provides a step-by-step guide to automate the process for multiple names effortlessly.

Simple Daily Reminder Email in Google Sheets

Learn how to set up a simple daily reminder email in Google Sheets using Apps Script, ensuring you never forget to check your tasks list again.

Add a Button To Automate Add a Row with Priority Status

Learn how to create a button in Google Sheets that automatically adds a new row with a priority status using Apps Script. This tutorial simplifies the process of managing tasks by allowing you to set priority levels with just a click.

Inventory Button in Google Sheets

Learn how to create inventory buttons in Google Sheets using App Script to easily increase or decrease inventory counts with just a click. This tutorial simplifies inventory management by automating the process, ensuring accurate tracking of stock levels.

Move Completed to Bottom of Google Sheet

Learn how to automate the process of moving completed tasks to the bottom of your Google Sheets using Google Apps Script. This tutorial walks you through the necessary code and logic to streamline your task management.