Skip to content
Formulas 101 companion doc
Formulas 101 companion doc
Formulas intro
Five formulas
Troubleshooting
Time and Concatenate
Behind the scenes
More
Share
Explore

icon picker
Five formulas

Practice the five formulas you need to know.

If you haven’t yet watched it,
open the lesson video
⁠
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
Blog Posts
⁠
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
⁠
⁠

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.
Reveal answer
⁠
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?
When was this row created?
1
Pizza
​
​
2
Salad
​
​
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.
Reveal answer
Lunch ideas answer table
0
Lunch Idea
Who changed this row last?
When was this row created?
1
Pizza
Rocky Moon
4/4/2023 11:45:51 AM
2
Salad
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
Blog Posts
⁠
that are featured OR meet both of the following conditions:
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
⁠
⁠


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:
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.
Reveal Answer
Opportunities answer view
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
) instead.