Google Sheets Tutorials · Better Sheets

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

How to Merge Cells in Google Sheets

A master class on merging cells. How to merge two cells. How to merge multiple cells. How to merge horizontally, vertically, and why. Create groups. Create headers. And how to merge automatically. Members get the sheet and the apps script down below.

Beginner

CONCATENATE() JOIN()

OpenAI API Prompt with Array of Cells

Create a prompt to OpenAI with an array of cells

Intermediate

CONCATENATE()

Move Cells to New Row with Formula

Move a range, or a set of cells, to a new area with a simple formula that's just "curly brackets". Very easy and simple to use once you know it.

Beginner

Move Blank Rows

Apps Script function to move all blank rows if a certain column is not filled in. Learn how to automate this script →Here

Intermediate

Automate Move Blank Rows

Automate the apps script we just created that moves blank rows from one sheet to the other sheet. Original tutorial to write the apps script

Intermediate

Reformat Pasted Cells Automatically

Create uniform formatting even if you're copy and pasting data that is differently formatted.

Intermediate

Go to Specific Cell When Spreadsheet is Opened

Create an automation that goes directly to a cell you pick every time you open the spreadsheet file.

Beginner

How to Format Timestamp to Day and Month

Create a formatted timestamp to the full name of the day and month.
Formats here: https://developers.google.com/sheets/api/guides/formats

How To Get Someone to look at a Cell in Your Sheet

Some helpful tips on how to get someone to look at a particular cell in your sheet.

Beginner

Use COUNTUNIQUEIFS Multiple Conditions to Count Weekdays of Sales

Analyze sales with COUNTUNIQUEIFS Formula.

Intermediate

COUNTA() FILTER() TEXT() UNIQUE()

How To Change Date Format Automatically

Create automations to change date format based on the format you want, inside your sheet.

Advanced

How To Format Sheets for Notes

Create sortable notes in Three ways.
1. By adding the original word over and over again
2. Adding notes all in one cell with CMD + ENTER for new lines
3. Use Apps Script to sort the A column even with groups of rows.

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()

Add Character Count and Character Limit

I'm gonna show you how to make a character counter and then account characters. And then I'm also gonna show you how to make a limit. It's really simple. It's one formula and some conditional formatting

Beginner

LEN()

Anders Asks: Can I Highlight Whole Row if Certain Columns have text?

Yes, using conditional formatting we can do this.

Conditional Formatting Beginner

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition, even if that condition is a date.

SUMIF() UNIQUE()

How To Export Your Beautiful Sheets to PDF

Want to create sleek, stunning PDFs from your Google Sheets? Look no further! Learn how to easily export your sheets to PDF format and impress your audience. Create a PDF from your Google Sheet.

Beginner

Search for Photos in a Google Sheet

This feature is really handy for designers who want to create notes around designs and mockups to showcase to clients. As a photographer, I can also use this to create a searchable sheet with keywords for my photos. You can even use screenshots instead of Unsplash photos like I'm using here. Basically, all you have to do is insert the images into cells and use V lookup to search for them using the ID numbers. You can use this to mock up a newsletter, test out different thumbnails as a YouTuber, or create a landing page or workflow for your business. It's really easy to change the photos by just changing the ID number.

VLOOKUP()

Extract URLs from Google Sheets

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

Displaying items 21-40 of 45 in total

TAGS

FORMULAS

TOPICS

45 Google Sheet Tutorials

An exclusive library of Google Sheet Tutorials

Why Different Cell References in AI Integration in Sheets?

How to Merge Cells in Google Sheets

OpenAI API Prompt with Array of Cells

Move Cells to New Row with Formula

Move Blank Rows

Automate Move Blank Rows

Reformat Pasted Cells Automatically

Go to Specific Cell When Spreadsheet is Opened

How to Format Timestamp to Day and Month

How To Get Someone to look at a Cell in Your Sheet

Use COUNTUNIQUEIFS Multiple Conditions to Count Weekdays of Sales

How To Change Date Format Automatically

How To Format Sheets for Notes

3 Ways to Count in Google Sheets

Add Character Count and Character Limit

Anders Asks: Can I Highlight Whole Row if Certain Columns have text?

Hardest Formula: SumIF | Addition Based on Dates / Values

How To Export Your Beautiful Sheets to PDF

Search for Photos in a Google Sheet

Extract URLs from Google Sheets