How To Use FILTER() Function in Google Sheets

Use Google Sheets to quickly find pages we can optimize. Using data directly from Google Search Console. Also check out the simple formula combination: AND() with IF()

Optimize SEO with Google Sheets and Google Search Console

IF() FILTER() SORT() AND()

tactics on how to keep your sheets secure.

Secure Your Sheets by BetterSheets.co

MATCH() FILTER() MIN() INDEX() ARRAYFORMULA()

How to create a video checklist. Create a sheet with check boxes that you check off to mark the videos as seen. Great for those creating lead magnets or checklist digital products. Enables you to create a video course without having to download/upload any videos. Your users can keep track of their progress and get all the benefit of your knowledge.

Better Sheets Videos Checklist

Data validation Beginner

FILTER() SORT() SPARKLINE() COUNTIF() COUNTA() +1 more

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!

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

IF() FILTER()

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.

Great if you're assigning work to VAs or you just became overloaded with tasks in your own task management system.

A great alternative to Conditional Formatting as well.

And a sneaky new little Apps Script that saves the day.

FILTER Can Save You From Task Overload

FILTER()

How to Power Testimonials with Google Forms and Sheets

I show you how I use a Google Form and a Google Sheet to power the testimonials page on BetterSheets. I walk you through the process of collecting testimonials, approving them, and displaying them on the website. I also explain how I implemented the functionality using Apps Script. If you're interested in learning about spreadsheet automation and how to leverage Google Forms and Sheets for your own projects, this video is for you!

And Spreadsheet Automation 101 is a great way to learn most of what I go over in this video.

Advanced

IFNA() FILTER()

Create a chat interface inside of Google Sheets using GPT-4. Insert rows as prompts get written. This sheet will help us ultimately write better prompts. We can actually tell the difference between what we're doing to get good vs bad response from the prompts.

Ultimate Prompt Writer and Prompt Rater

Data validation Advanced

IFERROR() FILTER()

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

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

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

Create a data entry form for an expense tracker. Simple dashboard too with sum and sum between two dates.

Expense Tracker Template with Data Entry Form Inside Sheets

SUM() FILTER() IFNA()

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!

Add A Timestamp to Task Lists (without Now Formula)

NOW() FILTER()

Make a marketplace where sellers and buyers do not have to have edit access to a sheet.

How to Make a Marketplace in a Google Sheet

FILTER() UPPER() ARRAYFORMULA()

Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.

Creating A Dark Mode Theme | Announcing Dark Habits

Better Domain Portfolio Template

Create a better list of domains.

MATCH() MAX() INDEX() FILTER() COUNTA() +1 more

Go inside this apps script and sheet. See how it's designed and created.

Deep Inside Dark Habits Google Script

ARRAYFORMULA() ISBLANK() TRANSPOSE() FILTER() INDEX() +3 more

Add pictures to your marketplace inside a google sheet. Might be great for garage sales, and community events.

Add Pics to Marketplace in a Google Sheet

MATCH() FILTER() IMAGE() INDEX()

We're going to like take some data, twist it and turn it into a different type of like look and feel. And then we're going to do the same thing in reverse.

Quadrant to List and List to Quadrant

FIND() FILTER() IFERROR() IF() JOIN()

Organize leads, life tasks, chores, assignments, anything into a kanban or trello board.

Organize Anything! - Build a Kanban Board / Trello Board

UNIQUE() COUNTA() FILTER() TRANSPOSE()

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.

Tagging Titles, Create a Comma Separated List of Tags

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

IF() ISBLANK() TRANSPOSE() UNIQUE() COUNTIF() +3 more

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.

Manage Your Wedding Guest List in Google Sheets

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

Learn how to find duplicates with a simple formula in Google Sheets.

How to Find Duplicates

IF() MATCH() ROW() CONCATENATE() FILTER()

Dates are numbers so you can filter them with greater than and less than.

How To Filter Dates (They Are Numbers Too!)

FILTER() IFERROR()

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

Add Team Members to the Quick CRM

FILTER() IMPORTRANGE()

Figure out who won a game of tic tac toe. inside a Google Sheet. Great for teachers and educators.

Tic Tac Toe In A Google Sheet

IF() AND() INDIRECT() FILTER() NOT() +4 more

Stick around after the 1st portion of the video for bonus content.

Create a Public Sheet and Private Sheet: Using ImportRange()

FILTER() IMPORTRANGE()

Go from nothing to a working PR agency. Capture sites, and Send email via script

Create a PR Agency From Scratch

SPLIT() ARRAYFORMULA() JOIN() FILTER()

Send daily emails to yourself to master sales every single day. 100% completely free for Better Sheet members.

Announcing Sell Daily and How I Built Sell Daily

ROUND() HYPERLINK() IF() MATCH() INDEX() +3 more

Got this question in the Facebook Group: How to count the number of numbers in a row. I saw two possible solutions mentioned in the comments and wanted to go through why those are okay but there is a much more flexible and better solution.

How to Count Numbers in a Row

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

Introduction to creating a filter so that you can bill for a certain time period of hours. Great sheet for Freelancers or Gig Workers.

Invoicing in Google Sheets for Freelancers

FILTER() IFNA() SUM()

Learn how to import DropCatch data with 100,000 domains into a Google Sheet. Find out how to get a filtered list of domains with sheet in them. And how to generate ideas of what to build based on these found domains.

Leveraging Expired Domain Names for Google Sheets Business: The speaker discusses using expired domain names to create and sell Google Sheets templates or tools. He demonstrates how to find domain names related to 'sheets' and suggests creative business ideas around them.

Importing and Analyzing Data in Google Sheets: The process of importing CSV data into Google Sheets and manipulating it to find specific information (like domains containing the word 'sheet') is showcased. This highlights the versatility of Google Sheets in handling and analyzing data.

Idea Generation and Business Opportunities in Google Sheets: The speaker, Andrew Kamphey, provides several examples of how to generate business ideas using Google Sheets. He suggests various niches like WordPress-related spreadsheets, balance sheets for accountants, and even educational tools like math workbooks, demonstrating the wide range of potential applications for Google Sheets in various domains.

A Few New Spreadsheet Business Ideas

FILTER() ARRAYFORMULA() LOWER() IF() IFERROR() +1 more

Learn how to use apps script to add emoji animations when you complete a checklist in Google Sheets.

Celebrate Your Completed Checklists

Advanced Intermediate

RAND() INDEX() IF() COUNTIF() IFNA() +3 more

Find out how many people attended each event even if they are double counted in attendee lists.

Count Unique Attendees For Each Event

COUNTUNIQUEIFS() UNIQUE() COUNTUNIQUE() SUM() FILTER()

Built a Domain Availability Checker in Google Sheets. You can build your own with the code provided. Use RapidAPI and Domainr.com to get an APIEKY for your own free checker.

Learn how to integrate sheets with a TLD Availability API.

Build Your Own Free Domain Availability Checker

IF() ISBLANK() FILTER() ARRAYFORMULA()

Create a status flow chart, like a kanban board but for displaying coffee orders.

Recreate a Starbucks Order Status Sign

FILTER() IF() ISBLANK() SEQUENCE() COUNTA()

Now you can select multiple options in a dropdown. Hip Hip Hooray!

Allow Multiple Selections is in Google Sheets Yay!

IFNA() SPLIT() JOIN() TRANSPOSE() FILTER() +1 more

Using the ampersand and ARRAYFORMULA to combine two filters into a single column.

Combine Filters in One Column

ARRAYFORMULA() FILTER()

Analyze sales with COUNTUNIQUEIFS Formula.

Use COUNTUNIQUEIFS Multiple Conditions to Count Weekdays of Sales

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

SearchLord: One Sheet to Search Them All

I created a new product called SearchLord. It's free for now and really fun to search multiple sites with 1 key word, or 1 phrase. Free for everyone at bettersheets.co/sheetlord

In this video I add 1 more feature to SearchLord to show you how to use a FILTER() function. And we add a custom menu with a little quick apps script function.

Beginner Intermediate

SUBSTITUTE() ENCODEURL() FILTER() IFNA()

Learn how to harness Google Sheets' new multi-select dropdown feature in this tutorial. We'll guide you through setting up dropdowns that allow multiple selections, using search and filter formulas to analyze and display data efficiently. By the end, you'll be able to create dynamic reports and dashboards, streamlining your workflow and enhancing data management. Perfect for those looking to get the most out of Google Sheets' latest functionality!

How to Filter Multi-Select Dropdown Feature

FILTER() SEARCH() SUM()

Create a simple automated help desk ticketing system.

Automate Help Desk Ticket Closing

Create tickets
Closed dropdown
Calculate time to close
Create dashboard

IF() COUNTA() COUNTIF() FILTER() AVERAGE()