Google Sheets Tutorials · Better Sheets

Create a Trello Board with Transpose Formula in Google Sheets

Use Transpose() to create a web-based, Kanban style, list-making application inside your Google Sheet! Learn how to display tasks and to-do’s in vertical categories.

Learn Google Sheet Formulas The Hard Way

One weird way to learn more about what Google Sheets can do. https://bettersheets.co/formulas

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our Add-on we'll be publishing to the Google Workspace Marketplace.

One Weird Google Sheet Formula for Bulk Publishing With AI

'll show you a game-changing Google Sheet formula that will make your day, especially if you're into bulk publishing and chat GPT. With this formula, you'll be able to insert lists of keywords into prompts effortlessly. I'll guide you step-by-step on how to set it up and use it effectively. Get ready to become faster, better, and more efficient in your publishing tasks. Let's dive in!

Intermediate

IF() ISBLANK() SUBSTITUTE()

REGEXMATCH Formula Generator for Google Sheets

Revolutionize the way you handle data with the BetterSheets REGEXMATCHER! Imagine having the ability to effortlessly validate text patterns, ensuring the integrity of your data. Whether you're searching for specific mentions, cleaning up unwanted content, or filtering out irrelevant information, our REGEXMATCHER is your go-to solution.

Error-Free Data:

Experience precise data validation ensuring your information is accurate and error-free.

Effortless Pattern Recognition:

Easily identify and eliminate unwanted data patterns, guaranteeing a clean and organized dataset.

Tailored Data Classification:

Classify your data based on specific patterns, streamlining your workflow and increasing efficiency.

Advanced

IF() REGEXMATCH()

How to Make Hangman Game In Google Sheets

Learn to create a fun game called Hangman in Google Sheets with Better Sheets. Watch the video to challenge yourself and see how it works. What other games can you make inside of Google Sheets? Create a game of hangman inside Google Sheets. Showcases a few Google Sheet formulas like SEARCH()

COUNTA() IF() IFERROR() JOIN() LEN() +1 more

Search Every Function in Google Sheets

Built a useful tool to filter Google Sheet formulas based on keywords.

3 Ways to Count in Google Sheets

The video explains three ways to count cells or information in Google Sheets: using the Explorer, using the COUNT function, and using the COUNTALL function. The Explorer is a tool located at the bottom right of the screen that allows you to quickly understand your data and find the count of items in a column. The COUNT function allows you to count the number of cells that contain numbers in a range of cells, while the COUNTALL function counts all the cells in a range, including those that contain formulas or are blank. The video also mentions other functions such as SUM and UNIQUE

Beginner

COUNTA() COUNTIF()

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

There was a stories craze. Every app/platform/business was adding 24 hour lasting videos to their users accounts. Now you can do that with Google sheets.

CONCATENATE() IF() IMAGE() INDEX() ISBLANK() +1 more

Why Code in Google Sheets? - Learn to Code in Google Sheets Part 1

welcome to part one of Learn to Code in Google Sheets. In this video, we're gonna get started to code.

Beginner

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

Create a click Edit: Google changed how the redirect is handled. It no longer automatically goes forward, so you will need to add a link for a user to click on again to go to the forwarded link.

Advanced

HYPERLINK()

Create A Video Course in a Google Sheet | LMS in a Google Sheet

Set up a list of video links, and a checklist for others to use.

Conditional Formatting Data validation Intermediate

COUNTA() COUNTIF() IF() SPARKLINE()

What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users

Learn about triggers, hourly, daily, weekly, etc.

Intermediate

Google Sheets Error: Unknown Range Name and How to Fix it

Unknown Range Name means we've typed in a formula the wrong format of a sheet name. I show you how to fix that and some other errors that might pop up.

Beginner

Manage Your Wedding Guest List in Google Sheets

Learn how to manage any event with RSVPs and multiple organizers. Use Google Forms pre-filled links, and interesting formulas to manage the catering automatically. And we write Apps Script to send email to non-rsvp'ed guests.

COUNTA() COUNTIF() FILTER() IFERROR() MATCH() +1 more

How to Use AND(), OR() in IF() in Google Sheets For Multiple Criteria

One of the most simplest and useful formula combinations is using and and or inside of an if and what happens is we want to use this when we want an if formula to have multiple criteria.

Beginner

How to Use AND() and OR() in IF() in Google Sheets For Multiple Criteria

One of the most simplest and useful formula combinations is using and and or inside of an if and what happens is we want to use this when we want an if formula to have multiple criteria.

Beginner

AND() IF() OR()

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a more elegant solution in Apps Script using JsDoc syntax to create an autocomplete native function. We use the formula combination of Concatenate / Round to create the ratio, but in Apps Script we do it a whole lot better.

Intermediate

CONCATENATE() ROUND()

3 More Ways to Count in Google Sheets

Learn how to use CountBlank() and more counting formulas.

Beginner

COUNTBLANK() COUNTIFS() COUNTUNIQUE()

Sheet Styles A Free Google Sheet Add-on by Better Sheets

Install Sheet Styles now: https://sheet-styles.bettersheets.co/

Displaying items 1-20 of 339 in total

TAGS

FORMULAS

TOPICS

339 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Create a Trello Board with Transpose Formula in Google Sheets

Learn Google Sheet Formulas The Hard Way

Write Apps Script to Create a New Google Sheets Formula

One Weird Google Sheet Formula for Bulk Publishing With AI

REGEXMATCH Formula Generator for Google Sheets

How to Make Hangman Game In Google Sheets

Search Every Function in Google Sheets

3 Ways to Count in Google Sheets

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

Why Code in Google Sheets? - Learn to Code in Google Sheets Part 1

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

Create A Video Course in a Google Sheet | LMS in a Google Sheet

What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users

Google Sheets Error: Unknown Range Name and How to Fix it

Manage Your Wedding Guest List in Google Sheets

How to Use AND(), OR() in IF() in Google Sheets For Multiple Criteria

How to Use AND() and OR() in IF() in Google Sheets For Multiple Criteria

Calculate ROAS in Google Sheets

3 More Ways to Count in Google Sheets

Sheet Styles A Free Google Sheet Add-on by Better Sheets