Filter

Explore

Gallery

Filter

⁠

Formula: Filter()

Category: Filters

⁠

Filter()

Retrieves a list of values that match whatever filter you create.

Or, put otherwise...

Hey Coda, can you look at this table and give me all rows that match this specific criteria?

Filter() uses two parameters:

⁠

List

Filter(List, Expression)

This is the table or list you want to filter.

⁠

Expression

Find(List, Expression)

The formula that describes the information you want to extract.

⁠

Filter() is a contender for the top three “must-know” formulas in Coda. It’s one of the primary formulas used in extracting and focusing on meaningful information from your tables or lists.

Let’s See How Filter() Works

Given the definitions we have above, let’s see how the formula works with examples. For now, we are going to take a look at the

People Database⁠

and extract specific information from it.

All people over 79 years old

⁠

@Bryan Johnson

⁠

All people with a salary > than $147,000

⁠

@Brandon Kennedy

⁠

All people who’s name starts with “N”

⁠

@Nathan Garcia @Nicole Rice

⁠

You can also use Filter() to return rows that match multiple criteria!

All people who have a birthday in January and who are over 71

⁠

@Sharon Foster @Anthony Baker

⁠

Now let’s learn to use Filter() to unlock some real Coda magic!

The Filter() formula becomes especially powerful when used to summarize or lookup information from another table. For example, take these two tables below and their tasks. All the task information you see in the yellow columns is thanks to our Filter() formula!

Go ahead and play these these tables. Notice how the task numbers automatically adjust depending on how many you add and how many you mark as “complete.”

To Do Table

To Do Table

Project

Task Lookup

All Tasks

Complete Tasks

Incomplete Tasks

Clean Kitchen

Clean Floors

Clean Counter

Lick the fridge

Make Lunch

Cook pasta

Wash dishes

Eat!

There are no rows in this table

⁠

Tasks

Tasks

Task

Project

Complete

Cook pasta

Make Lunch

Wash dishes

Make Lunch

Clean Floors

Clean Kitchen

Eat!

Make Lunch

Clean Counter

Clean Kitchen

Lick the fridge

Clean Kitchen

There are no rows in this table

⁠

Project Selects

Project Selects

To Do

Make Lunch

Clean Kitchen

There are no rows in this table

⁠

Practice: Demonstrate your understanding of Filter() basics

Done

Identify the number of people that fall within a certain salary band

Done

Analyze the success of a Kit-Activation campaign

Done

⁠

Gallery

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.