Gallery
Filter
Share
Explore

icon picker
Filter

Formula: Filter()
Category: Filters
filtration.svg
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:
ingredients-list (4).svg
List

Filter(List, Expression)

This is the table or list you want to filter.
google-code (1).svg
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
image.png
@Bryan Johnson

All people with a salary > than $147,000
image.png
@Brandon Kennedy

All people who’s name starts with “N”
image.png
@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
image.png
@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
Project
Task Lookup
All Tasks
Complete Tasks
Incomplete Tasks
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
Tasks
1
2
3
4
5
6
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
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
) instead.