Google Sheets Tutorials · Better Sheets

Create a Stop Watch in a Google Sheet

We'll create a stop watch from scratch. Including Apps Script. What it will do is when you click a button (a checkbox) in a sheet, the script on every edit will add a start or a stop time, then add another time and calculate the duration.

Google Sheets Interface Changes

Showing off New experiences in smart canvas changes to sheets. Including Date Chips, and Files Chips. Introduced in early 2023.

Create Hundreds of Tweets in a Google Sheet

Write tweets fast! Create hundreds of tweets in a Google sheet with ease and tweet each other's tweets! Learn how to do it with our step-by-step guide

Add Icons To Your Sheets With a Domain Name

Add visual flair to your Google Sheets when sharing company domain information. You’ll learn how to use an undocumented Google API. ( Easier than you think!)

How to Make An Easter Egg Hunt in a Google Sheet - by BetterSheets.co

Create a pastel colored hunting game, just in time for Easter.

Intermediate

COUNTIF() IF()

Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!

Combine Databases and Backup Your Information Effortlessly - Learn how to merge two databases and compare backups with ease. Get all the information you need from past years and multiple sheets. Follow our step-by-step guide and simplify your data management today!

Intermediate

IMPORTRANGE()

Create a Radio Button From Checkboxes Using Google Apps Script

Let's code a Radio button that turns off all checkboxes except the one clicked.

Data validation Advanced

IFS() NOT() OR()

LinkTree in a Google Sheet

This tool will allows you to share multiple links on your social media.

Advanced

Convert Your Bullet Journal To Google Sheets

Find out how you can make your spreadsheets like a Bullet Journal. It's like a super powered Bullet Journal.

Beginner

VLOOKUP()

Extract URLs from Google Sheets

When you can't get the url of a hyperlinked cell, do this instead.

Password Protecting Data In a Google Sheet Part 2 The Basics

Covering some of the basics I skipped over in the part 1 video.

Advanced

IF() IMPORTRANGE()

How to Write a Function - Learn to Code in Google Sheets Part 2

Continuing to show you how to write a function in Apps Script.

Beginner

Now Do It Every Damn Day - Learn to Code in Google Sheets Part 5

Now that we have a script that we wanna run every day, how do we run this? This is a key part of programming. It's like Cron Jobs in Apps Script

Advanced

Hold a Giveaway Raffle in a Google Sheet

Get a random winner from a list of names. Also great to randomize tasks to do.

ChatGPT Clone in Google Sheets Part 2

We fix the problem of OpenAI's API not remembering our last questions. And we label the text as Human and AI. I also add an archive Chat and new Chat function to create a new chat fresh.

Advanced

World Peace in Google Sheets

Combining GoogleTranslate() and DetectLanguage() to figure out what a language is without having to know the two letter codes. And adding a dropdown range to make it easier to find the language you want to translate to. What a great way to solve the frustrating world of International language!

Beginner

DETECTLANGUAGE() GOOGLETRANSLATE() VLOOKUP()

Upgrade Google Sheets OpenAI Prompt to GPT 4

Upgrade to OpenAI's GPT 4 in your Google Sheets. And use GPT-3.5: Turbo for Powerful AI Prompt Calls!

Learn how the new model enhances chat capabilities, including distinct messages and system prompts. Boost your productivity by integrating AI into your Google Sheets.

Advanced

LEN()

Add Title Case to Google Sheets

Discover the Ultimate Google Sheets Hack! Transform Text with Title Case Formula. Say Goodbye to 'Proper' and Hello to Easy Capitalization. Find Out How!

Advanced

Why Different Cell References in AI Integration in Sheets?

Find out How to Optimize your Apps Script functions. Learn the trade offs between flexibility, edit-ability, and protection. Different cell references allow you to do more with your apps script.

In the context of the video we're talking about an AI prompt and how I used different Cell References when writing different Apps Script functions. I'll show you why I chose those syntaxes and why you might choose different ones.

This video is more about Apps Script than writing Prompts but can help you create better web apps inside of Google Sheet, utilizing the best of Apps Script and creating your own custom functions.

Advanced

Displaying items 81-100 of 355 in total

TAGS

FORMULAS

TOPICS

355 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Create a Stop Watch in a Google Sheet

Google Sheets Interface Changes

Create Hundreds of Tweets in a Google Sheet

Add Icons To Your Sheets With a Domain Name

How to Make An Easter Egg Hunt in a Google Sheet - by BetterSheets.co

Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!

Create a Radio Button From Checkboxes Using Google Apps Script

LinkTree in a Google Sheet

More LinkInBio Templates for Google Sheets | SheetInBio

Convert Your Bullet Journal To Google Sheets

Extract URLs from Google Sheets

Password Protecting Data In a Google Sheet Part 2 The Basics

How to Write a Function - Learn to Code in Google Sheets Part 2

Now Do It Every Damn Day - Learn to Code in Google Sheets Part 5

Hold a Giveaway Raffle in a Google Sheet

ChatGPT Clone in Google Sheets Part 2

World Peace in Google Sheets

Upgrade Google Sheets OpenAI Prompt to GPT 4

Add Title Case to Google Sheets

Why Different Cell References in AI Integration in Sheets?