Skip to content
HintThis 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
HintAdd .First() at the end of a list to just return the first item in that listAnswer
HintOnce you find the row you’re looking for with the filter criteria, just add a .Author to the end of the formula.Reveal answer
HintUse the word OR in between your filter criteriaAnswer
HintRemember, the categories are rows, so you can use dots to drill down and select column values (like checkboxes...cough cough hint hint)...from those rowsAnswer
Hint 1Use parentheses to separate the first criteria from the last twoHint 2When a lookup is multiselect, you can’t use the = sign. Instead, you have to use CONTAINS() Answer
the category description is less than 100 characters or has 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 1The YEAR() formula might come in handy...AnswerTip to read only after you solve itIt’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:
Filter Workout Routine
Let's get this workout started!
Exercise 1
Your answer:
24
No results from filter
Exercise 2
Use FILTER() to return the first category listed in with the “Selected” column unchecked
Your answer:
@Maria's column
No results from filter
Exercise 3
Use FILTER() to find the author of the blog post whose category is and the post is featured.
@Launch
Your answer:
@Shishir Mehrotra
No results from filter
Exercise 4
Use FILTER() to find the number of that either have the category or the category .
@Launch
@Puzzles
Your 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:
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 in the Type column and
@Type A
2) as the category.
@Product
Your answer:
3
=
No results from filter
Exercise 7 - Bonus Question!
Return a bulleted list of blog posts where either:
@Type B
Your answer:
@It’s a new day for docs.
@Remodeling the Coda user experience
@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.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.