Tag: Google Sheets

How To Apply Conditional Formatting Across An Entire Row In Google Sheets

Conditional formatting is a super useful technique for formatting cells in your Google Sheets based on whether they meet certain conditions.

In this post, you’ll learn how to apply conditional formatting across an entire row of data in Google Sheets.

For example, if the continent is “Africa” in column C, you can apply the background formatting to the entire row (as shown by 1 and 2):

Conditional formatting across an entire row

A template with all these examples is available at the end of this post.

Continue reading How To Apply Conditional Formatting Across An Entire Row In Google Sheets

Build Numbered Lists With The Amazing SEQUENCE Function

The SEQUENCE function is a useful function in Google Sheets. It’s a powerful way to generate numbered lists.

SEQUENCE Function Syntax

=SEQUENCE(rows, columns, start, step)

As arguments for the SEQUENCE function, you specify 1) the number of rows, 2) the number of columns, 3) a start value, and 4) a step size.

Arguments 2, 3, and 4 are optional. However, if you want to set them you need to include the previous ones (e.g. if you want to set a step size in argument 4, then you need to set 1, 2, and 3 as well).

Keep this order in mind as you look through the examples below and you’ll soon understand how the function works.

1. Ascending list of numbers

=SEQUENCE(5)

=SEQUENCE(5)

Continue reading Build Numbered Lists With The Amazing SEQUENCE Function

How To Create QR Codes in Google Sheets Using Formulas

In this tutorial, you’ll learn how to create QR Codes in Google Sheets using formulas. And how to transfer them to Google Docs and Google Slides using Apps Script.

A QR code is a type of matrix barcode.

Barcodes and QR codes are optical labels that are machine-readable and link to information about items or products.

They’re ubiquitous today. You see them everywhere, from restaurant menus to packaging labels.

In this post, we’ll look at how to create fully-functional QR codes in Google Sheets.

QR Codes In Google Sheets
Continue reading How To Create QR Codes in Google Sheets Using Formulas

How I Used Google Forms, AI, and Apps Script Automation to Analyze 1,700 Survey Responses

This post describes how I designed and ran an audience survey with over 1,700 responses, using Google Forms, Sheets, Apps Script, and ChatGPT. I’ll show you the entire process from end-to-end, including how I:

  1. Created a survey with Google Forms
  2. Used Apps Script to automatically say thank you to 1,700 respondents
  3. Analyzed the response data in Google Sheets
  4. Used AI to help me understand the qualitative data
  5. Presented the results in Google Docs

This flowchart shows how the system is set up:

Survey Flow Chart
Continue reading How I Used Google Forms, AI, and Apps Script Automation to Analyze 1,700 Survey Responses

The LEN Function in Google Sheets

The LEN function in Google Sheets is a simple but useful function that counts the number of characters in a given string.

Basic LEN Function Google Sheets

If you’re working with text data in spreadsheets then you’re likely to use the LEN function. It becomes particularly powerful when combined with other functions to manipulate and analyze strings.

🔗 Grab the LEN template at the bottom of this article.

Continue reading The LEN Function in Google Sheets