Skip to content
Formula Fitness | Level Up your Filters
Share
Explore

icon picker
Filter Workout Routine

Let's get this workout started!

Exercise 1

Use FILTER() to find the number of that have the category
@Launch
Your answer:
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(....
Reveal answer
24
No results from filter


Exercise 2

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

Exercise 3

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

Exercise 4

Use FILTER() to find the number of that either have the category
@Launch
or the category
@Puzzles
.
Your answer:
Hint
Use the word OR in between your filter criteria
Answer
25
No results from filter

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).
Your answer:
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
Answer
23
No results from filter

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.
Your answer:
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()
Answer
3
=
No results from filter

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.

Your answer:
Hint 1
The YEAR() formula might come in handy...
Answer
@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
No results from filter



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.