Formula Fitness | Level Up your Filters

Filter Workout Routine

Data

My Progress

Explore

Filter Workout Routine

Let's get this workout started!

Exercise 1

Use FILTER() to find the number of

Blog Posts⁠

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

Categories⁠

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

Blog Posts⁠

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

Categories⁠

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

@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.