Skip to content
Copy of The learn doc
Welcome to Coda!
Learn by watching
Learn by doing
Relevant reading
More
Share
Explore
Learn by watching

icon picker
Formula essentials

Coda has a powerful formula language to help you build whatever you want. While the language is similar to what you’ve used in Excel, there are a few differentiators that make formulas easier to write and understand.
And if you’ve never used formulas before, don’t worry! Coda’s formula language is more accessible than you think. With our Formula Essentials video series, we’ll unpack the seven formulas that will benefit every Coda maker, whether you're leveling up your to-do list or building the perfect tool for your team.

Introduction

Knowing just a few formulas will take you a long way.
⁠
⁠
⁠

Filter formula

When you want to look at just one part of your dataset, use Filter formula.
⁠
⁠
⁠

User formula

Create personalized user experiences in your doc with User formula.
⁠
⁠
⁠

thisRow formula

Extrapolate and summarize your data with thisRow formula. Think of it like Coda's alternative to Excel battleship coordinates.
⁠
⁠
⁠

Contains formula

Extract the information you need with Contains formula.
⁠
⁠
⁠

Concatenate formula

Concatenate is a formula that strings information together and shows you how to create dynamic subject lines, buttons, and messages.
⁠
⁠
⁠

If & SwitchIf formulas

Get results based on a certain set of criteria with If and SwitchIf formulas.
⁠
⁠
⁠

FormulaMap

Apply the same action to a list of items in a table with FormulaMap.
⁠
⁠
⁠
⁠

Check your progress.

Here’s a view of your learning plan. What do you want to accomplish next?
Task
Time commitment
Status
1
Watch the
Coda essentials
⁠
videos.
80 mins
Done
2
Watch the
Formula essentials
⁠
videos.
30 mins
Not Started
3
Watch one set of
Coda in action
⁠
best practices.
30 mins
Not Started
4
Watch
Designing docs
⁠
videos.
75 mins
Not Started
5
Subscribe to the Coda webinar channel at
crowdcast.io/coda-hq
⁠
.
1 min
Not Started
6
Bookmark the links in
Relevant reading
⁠
.
1 min
Not Started
7
Watch remaining
Coda in action
⁠
videos.
90 mins
Not Started
8
Begin
Exercises
⁠
.
​
Not Started
9
Complete
Exercises
⁠
.
​
Not Started
10
Complete
Puzzles
⁠
.
​
Not Started
There are no rows in this table
5 hrs 7 mins
⁠
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.