Filter
Filter
Formula: Filter()
Category: Filters
Filter()Retrieves a list of values that match whatever filter you create.
Or, put otherwise...
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
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
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
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.