# Member Questions

37 Tutorials

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.

# 37Tutorials

the answer is if you have a column of true or false you can use the count if statement argument formula. That's just count if, and then you say your range, and then comma, true. Or false, whichever one you want and you'll get a count.
You're joining a company and they have some Google Sheets already created, and there's a sheet that has a cell in A1, this number, and you want to iterate it to 3, and B1 is connected to a lot of other stuff, so you don't want to mess with it. All you want to do is iterate a one, one at a time. I think the answer here is an Apps Script.
Create easy to use math iterators with the ROW() formula. It tells you the row your cell is on, but why do you need that? you can iterate math equations! It's neat!
Create relational databases with index/match. Discover the secret to efficient data management with primary keys! Learn how to sort, filter, and create tables based on unique identifiers in this expert video. Say goodbye to complicated spreadsheets and hello to easy data management.
Your question is, you have these events and dates and statuses. And you want to turn them green actually you wanna turn them any, some color, the whole entire row based on if in this D column the status is closed.
How to create a form programmatically using Google Apps Script. I show you step-by-step how to create a form, set the title, add text items, and set the destination of the form to a specific sheet. This tutorial is perfect for anyone who wants to automate the process of creating forms, whether it's for templates, lead magnets, or recurring forms. No prior coding experience is required.
Jodi asked:  ab out Building a sales CRM spreadsheet that has 4-5 tabs at the bottom. Each sales person gets their own sheet and then I want a master spreadsheet that pulls each salespersons Information they enter (customer, job, status etc) into one place.

I’m not sure how to get the master sheet to pull in from the other sheets as they enter the data so that the master sheet shows real-time what’s happening without making one row = a row from another sheet.  I just want it to come in one row after the next as it happens.

Other Videos Mentioned in this video:

The video tutorial is about tagging and creating comma-separated lists of tags for a list of titles. The tutorial demonstrates how to use data validation to create a drop-down menu of tags for each title and how to keep track of the number of videos or items in each tag category. The tutorial also shows how to create a comma-separated list of tags for each title using the JOIN function.
Find the first value in a row.
If you have a list of tasks and statuses, the FILTER formula will help keep you from the brink of Overload by allowing you see each status in a different tab.

A great alternative to Conditional Formatting as well.

And a sneaky new little Apps Script that saves the day.
I'll show you how to easily find a specific value in a range using two powerful formulas: VLOOKUP and INDEX MATCH.

With VLOOKUP, we can search for a value in a column and retrieve information from the same row.

I'll explain how to set it up and why the "false" parameter is important. Then, I'll introduce INDEX MATCH, which allows us to search for a value in one column and retrieve information from another column.

I'll demonstrate how to use it to find a name based on a number and vice versa. This technique is incredibly useful when you need to look up information based on a specific value.

Plus, I'll share a neat trick to make the search even more dynamic. So, let's dive in and master these versatile formulas together! 🚀
Go through a fun sheet and make it better.
She has a cell, this D one, in which it says, for instance, another array or a row or column in this case, a column, a on sheet one where we're on and she's referencing that from another cell.
Use arrayformula to deal with Google form entries on a sheet. Even as they keep getting added.
Find out how to get a formula to get a row, but get it multiple times per row.
Yes, using conditional formatting we can do this.
Find out how to automatically delete rows based on a cell's value. We do this in Apps Script
How to figure out a percentage score when our reporting numbers are a formatted in a particular way. In this case we have a score and then a slash and then the total possible score in a single cell. We go through each option of solution and try to derive a solution that is both useful in the exact situation and possibly useful for other problems too.

We find that the Query formula and other solutions are inflexible or time intensive. We want a solution that does actually solve the problem at hand, in a quick way, and also is easy to edit and flexible to solve other problems.
how would I do the following? In Google Sheets, it's in column A I have a list of URLs. For each of those URLs, I want to pull that URL's featured image and meta description, and put those in columns B and C. Here's how you do it. I just grabbed Wikipedia articles for this example.
We go deep into the syntax and usage of the SPLIT() formula.
Search through and filter data to get what you want, when you want it. Tired of sifting through endless rows and columns? Learn how to filter your Google Sheet database with dates, checkboxes, and dropdowns. Simplify your workflow today!
We have a question from Rupesh about the quick CRM. He wants to add some team members.
Useful for calculation or filters by dates.
ow do I show the date and time for the last time something was changed in a sheet? So what's interesting is that this This shows you Google Sheets shows an version history up here and shows you the last edit, but sometimes we want to have that data available to us inside of the sheet.
find out how to show the total number of data rows available in a sheet.
A member, Alejandro, asks about taking their custom calendar inputs and figuring out study totals for a week. They created a beautiful input and just need to the calculations. I show how to use the data to do the calculations. If you've never used the FLATTEN() formula, this is a good example! And we use double UNIQUE().
Got a list of names, need to add new ones to main list.
In Excel you actually have these options of sorting by year, by month, by date. But let's do it in Google Sheets.
Create a countdown timer inside of a google sheet. Unlock the secret to a lifetime deal... TIMEI! Discover their amazing live Google sheet and join the countdown to their exclusive offer. Watch as we recreate and enhance their sheet with stunning colors. Don't miss out on this epic journey. Click now!
So in this video we're going to compare two tabs and differences. Basically, someone asked actually on AppSumo, someone asked how do I compare two sheets to know what the differences are? This is the answer.
One common feature that users often request is the ability to add star ratings to their spreadsheets. While this feature is not built into Google Sheets, it is possible to create a star rating system using emojis and data validation.
Create a schedule inside of Google Sheets.
How can I use this function, lower, upper, or proper as a conditional formatting? And then the other question is, how can I use this to apply on a bunch of cells without having to double the cells?
How to add a timestamp to done tasks. Learn how to easily add timestamps to your done tasks! Say goodbye to manual formatting and hello to this simple code. Click now to save time!

Start a FREE TRIAL today to access this course.

Better Sheets