Formulas 101 companion doc
Share
Explore

# Five formulasFive formulas

## 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
@Launch
and the post is featured.
Hint
Once you find the row you’re looking for with the filter criteria, just add a .Author to the end of the formula.
@Shishir Mehrotra

## User

Add a formula so that the button label says the user’s name instead of “Click me.”
Click me
Hours
1
There are no rows in this table
Hint
Click the f icon in the label field of the button to add a formula.
Anonymous User

## thisRow

Create a formula that calculates who modified a row and when it was created.
Lunch ideas
0
Lunch Idea
Who changed this row last?
1
Pizza
2
3
Ramen
There are no rows in this table
Hint
You can type “=” into any column and the formula will be applied for the entire column.
Lunch ideas answer table
0
Lunch Idea
Who changed this row last?
1
Pizza
Rocky Moon
4/4/2023 11:45:51 AM
2
Rocky Moon
4/4/2023 11:45:51 AM
3
Ramen
Rocky Moon
4/4/2023 11:45:51 AM
There are no rows in this table

## Contains

Find the number of that are featured OR meet both of the following conditions:
Has
@Type A
in the Type column and
@Product
as the category.

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()
3

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

Opportunities
0
Deal
Stage
Person
1
Software
Prospecting
2
Hardware
Negotiating
3
Coffee Mugs
Closing
4
Software
Negotiating
There are no rows in this table

Hint 1
You’ll add the formula to the Person column.
Hint 2
There are multiple options to choose from in this formula.
0
Deal
Stage
Person
1
Software
Prospecting
Maria
2
Hardware
Negotiating
Laura
3
Coffee Mugs
Closing
Justin
4
Software
Negotiating
Laura
There are no rows in this table

## Up next: Troubleshooting⁠

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP