Gallery
Formula Fitness | Level Up your Filters
Share
Explore

# Filter Workout Routine

Let's get this workout started!

### Exercise 1

Use FILTER() to find the number of that have the category
@Launch
Hint
This is a good rule of thumb for most formulas: Start with the table, then add your formula with a dot. So in this case, start the formula with Blog Posts.Filter(....
24

### Exercise 2

Use FILTER() to return the first category listed in with the “Selected” column unchecked
Hint
Add .First() at the end of a list to just return the first item in that list
@Maria's column

### Exercise 3

Use FILTER() to find the author of the blog post whose category is
@Launch
and the post is featured.
Hint
Once you find the row you’re looking for with the filter criteria, just add a .Author to the end of the formula.
@Shishir Mehrotra

### Exercise 4

Use FILTER() to find the number of that either have the category
@Launch
or the category
@Puzzles
.
Hint
Use the word OR in between your filter criteria
25

### Exercise 5

Find the number of blog posts where the description has the word “Coda” somewhere in it AND has a category whose row in is selected (with the check box).
Hint
Remember, the categories are rows, so you can use dots to drill down and select column values (like checkboxes...cough cough hint hint)...from those rows
23

### Exercise 6

Find the number of blog posts that are featured OR meet both of the following conditions
1) has
@Type A
in the Type column and
2)
@Product
as the category.
Hint 1
Use parentheses to separate the first criteria from the last two
Hint 2
When a lookup is multiselect, you can’t use the = sign. Instead, you have to use CONTAINS()
3
=

### Exercise 7 - Bonus Question!

Return a bulleted list of blog posts where either:
the category description is less than 100 characters or has
@Type B
in the Type column...
AND
either:
(1) is authored by TJ Eby or
2) the publish date is in 2017.Sort the list alphabetically ascending by doc title.

Hint 1
The YEAR() formula might come in handy...
@It’s a new day for docs.
@Remodeling the Coda user experience
Tip to read only after you solve it
It’s hard to keep track of long filter conditions when they’re all squished together like this. So you can type Shift + Return within the formula builder to break up the formulas into different lines, like this:
@It’s a new day for docs.
@New building block: Automation
@Remodeling the Coda user experience