Filter
Share
Explore

# FilterFilter

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 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
0
Project
1
Clean Kitchen
Clean Floors
Clean Counter
Lick the fridge
3
2
1
2
Make Lunch
Cook pasta
Wash dishes
Eat!
3
1
2
There are no rows in this table
0
1
2
3
4
5
6
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
0
1
2
To Do
Make Lunch
Clean Kitchen
There are no rows in this table

Done
Identify the number of people that fall within a certain salary band
Done
Analyze the success of a Kit-Activation campaign
Done
Share

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP