### Exercise 1

Use FILTER() to find the number of that have the category Your answer:

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

### Exercise 2

Use FILTER() to return the first category listed in with the “Selected” column unchecked Your answer:

Add .First() at the end of a list to just return the first item in that list

### Exercise 3

Use FILTER() to find the author of the blog post whose category is and the post is featured. Your answer:

Once you find the row you’re looking for with the filter criteria, just add a .Author to the end of the formula.

### Exercise 4

Use FILTER() to find the number of that either have the category or the category . Your answer:

Use the word OR in between your filter criteria

### 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:

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

### 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 Your answer:

Use parentheses to separate the first criteria from the last two When a lookup is multiselect, you can’t use the = sign. Instead, you have to use CONTAINS() =

### Exercise 7 - Bonus Question!

Return a bulleted list of blog posts where either:

the category description is less than 100 characters or has in the Type column... (1) is authored by TJ Eby or 2) the publish date is in 2017.Sort the list alphabetically ascending by doc title.

Your answer:

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