Member Questions

About this topic

Better Sheets Member Questions
Questions directly from members answered, for you.

Watch this video to learn how to ask a question you have.

→ Get Sheets Help

These are questions about Google Sheets from members of Better Sheets. Questions directly from members answered, for you. The point of these videos is that one person had a problem, got the solution but also all Better Sheets members can now learn from that one video.

While these are questions FROM Better Sheets members they are all answered by Andrew Kamphey, the resident Google Sheets wizard at BetterSheets.co and you'll get that response from him every time. There's no forum (yet) on Better Sheets. There are searchable directory of Formulas, Tutorials, Templates, and Tools.

If you're not yet a member, and you want to ask a question, there are videos on how to best ask a question. It's best to make a question that is specific but not TOO specific. Not vague, and can be shown. Meaning you have a 1 minute loom recording, or a sheet to share. Sharing a sheet with fungible information is best so I can make a video response.

Don't share private data. Make sure the sheet is abstract enough to get your answer but not specific enough to have any revealing private data.

Tutorials

Ken Asks: How can I count true and false? Answer: w/ CountIF()

the answer is if you have a column of true or false you can use the coun...

Beginner

COUNTIF()

Can a Google Sheet have DRM?

Are you wondering if you can sell a google sheet and only allow buyers t...

Advanced

Use Row() For Math You Need to Iterate

Create easy to use math iterators with the ROW() formula. It tells you t...

Beginner

ROW()

Iterate Numbers with a Simple Apps Script

You're joining a company and they have some Google Sheets already create...

Beginner

How to Turn Background Color to Text

This tutorial showcases a practical solution to convert visual cues into...

Intermediate

David Asks: About Primary Keys

Create relational databases with index/match. Discover the secret to ...

Intermediate

INDEX() MATCH()

Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas

Automatically copy a spreadsheet tab to a whole new spreadsheet file, ge...

Intermediate

How to Replace Text with a Blank Cell in Google Sheets

Learn the Quick Fix! Replace Text with Blank Cell in Google Sheets Hassl...

Beginner

Sync Many Tabs without ImportRange()

Sync more than two tabs with Apps Script

Advanced

OpenAI API Prompt with Array of Cells

Create a prompt to OpenAI with an array of cells

Intermediate

CONCATENATE()

Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell

Your question is, you have these events and dates and statuses. And y...

Conditional Formatting Intermediate

Can I get alerted when a tab name is changed?

Find out in this quick experiment if a tab name can be alerted to the ow...

How To Duplicate a Tab and Move it to the End in Google Sheets

Learn how to automate creating a template and moving the tab to the far ...

Intermediate

How to Create a Google Form Automatically

How to create a form programmatically using Google Apps Script. I show y...

Intermediate

Scoping Functions in Apps Script

Create multiple functions that run with the result of other functions.

Advanced

Tagging Titles, Create a Comma Separated List of Tags

The video tutorial is about tagging and creating comma-separated lists o...

Intermediate

COUNTIF() FILTER() JOIN() TRANSPOSE()

Combine Sheets Into One Sheet As It Happens

Jodi asked: ab out Building a sales CRM spreadsheet that has 4-5 tabs a...

Intermediate

IMPORTRANGE() SORT()

Zakir Asks: Find First Car in a Row

Find the first value in a row.

Beginner

COUNTIF() INDEX() ISBLANK() MATCH()

Find Column with Header to Bullet Proof your Vlookup

Make your VLOOKUP formulas flexible and your data move-able with this tr...

Intermediate

HLOOKUP() MATCH() VLOOKUP()

FILTER Can Save You From Task Overload

If you have a list of tasks and statuses, the FILTER formula will help k...

FILTER()

Find a Value in a Range

I'll show you how to easily find a specific value in a range using two p...

Beginner

INDEX() MATCH() VLOOKUP()

Create an Automated Task List

I've created simple automations to make an awesome automatic task list. ...

Intermediate

Made a Conference Schedule Better - Member Request!

Go through a fun sheet and make it better.

Advanced

Anika Asks: How to Bring value from other cells | How to Reference an array in a cell

She has a cell, this D one, in which it says, for instance, another arra...

Intermediate

INDIRECT() SORT() TRANSPOSE()

How to Count Numbers in a Row

Got this question in the Facebook Group: How to count the number of numb...

Beginner

AND() COUNT() COUNTA() COUNTIF() FILTER() +1 more

Member Asks: How do I calculate from a set of Form entries?

Use arrayformula to deal with Google form entries on a sheet. Even as th...

ARRAYFORMULA()

Get Every Row 5 Times

Find out how to get a formula to get a row, but get it multiple times pe...

Intermediate

What is this Ampersand Doing in Google Sheets?

What is "&" doing in this formula? MONTH(A1&1) Do you know why this is s...

CONCAT() DATE() MONTH() VALUE()

Pick a Raffle Winner with Number of Tickets

Pick a raffle winner if you only have the names and number of tickets. A...

Advanced

ARRAYFORMULA() IF() INDEX() JOIN() RANDBETWEEN() +3 more

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

Yes, using conditional formatting we can do this.

Conditional Formatting Beginner

Dylan Asks: How to Automatically Delete Rows If Cell Contains Value

Find out how to automatically delete rows based on a cell's value. We do...

Advanced

Kristy Asks How to Get Percentages from Scores

How to figure out a percentage score when our reporting numbers are a fo...

Beginner

ARRAYFORMULA() IF() INDEX() ISBLANK() LEFT() +3 more

Zunaid Asks: How to get Get Meta from URLS? Answer: Use ImportXML()

how would I do the following? In Google Sheets, it's in column A I have ...

Advanced

IMPORTXML()

User Filter a Google Sheet Database based on Dates, Checkboxes, Dropdown!

Search through and filter data to get what you want, when you want it. T...

Beginner

FILTER() IF()

How Does Split Work?

We go deep into the syntax and usage of the SPLIT() formula.

Beginner

SPLIT()

Add Team Members to the Quick CRM

We have a question from Rupesh about the quick CRM. He wants to add some...

Intermediate

FILTER() IMPORTRANGE()

Anders Asks: Find first and last of filter by date

Useful for calculation or filters by dates.

Beginner

COUNT() IF() INDEX()

Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?

ow do I show the date and time for the last time something was changed i...

NOW()

Bjarne Asks: Can I show the total number of rows minus the header row?

find out how to show the total number of data rows available in a sheet.

Beginner

COUNTA() COUNTBLANK() SUM()

Alejandro Asks: How do I Sum up Study hours from a Calendar Format?

A member, Alejandro, asks about taking their custom calendar inputs and ...

FILTER() FLATTEN() SORT() SUM() UNIQUE()

Ben Asks: How Do I Add 1 Month?

Member Ben asks how to add 1 month to a date.

Intermediate

CONCATENATE() EDATE() TEXT() TODAY()

Wallace Asks: How To Find New Names

Got a list of names, need to add new ones to main list.

ARRAYFORMULA() IF() IFERROR() ISBLANK() MATCH()

Ian Asks: How to sort dates by year/month (can't do with filter)

In Excel you actually have these options of sorting by year, by month, b...

Pabbly Connect Countdown - "Sheet Improvement!"

Create a countdown timer inside of a google sheet. Unlock the secret to ...

Richard Asks: Copy Template Tab and Rename to Date Every Week

Member Richard asks this question. Answer: use Google Script and a Trigger.

How Can I Compare Two Tabs for Differences?

So in this video we're going to compare two tabs and differences. Basica...

COLUMN() IF() INDEX() INDIRECT() ROW()

Ken Asks: Can We Add Star Ratings?

One common feature that users often request is the ability to add star r...

Beginner

AVERAGE() SWITCH() VLOOKUP()

Benoit Asks: How to Convert Case

How can I use this function, lower, upper, or proper as a conditional fo...

ARRAYFORMULA() LOWER() PROPER() UPPER()

How To Select an Image based on Text in a Dropdown Menu

This video is a tutorial on how to create a dynamic weekly planner in Go...

INDEX() MATCH() VLOOKUP()

Add A Timestamp to Task Lists (without Now Formula)

How to add a timestamp to done tasks. Learn how to easily add timestamps...

Advanced

FILTER() NOW()