## Practice the five formulas you need to know.

If you haven’t yet watched it, in a new tab. Then, complete the exercises for each of the five formulas you need to know. There are hints to help you along the way, and you can check your answers when you’re finished.

## Filter

Use FILTER() to find the author of the 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.

## User

Add a formula so that the button label says the user’s name instead of “Click me.”

Click the f icon in the label field of the button to add a formula.

## thisRow

Create a formula that calculates who modified a row and when it was created.

Who changed this row last?

When was this row created?

You can type “=” into any column and the formula will be applied for the entire column. Who changed this row last?

When was this row created?

## Contains

Find the number of that are featured OR meet both of the following conditions: 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()

## If and SwitchIf

We have a different team member in charge of each phase in the deal. We want the person to be assigned to once we change the phase:

Prospecting should belong to Maria Negotiating should belong to Laura Closing should belong to Justin

Your answer:

You’ll add the formula to the Person column. There are multiple options to choose from in this formula. Opportunities answer view

0