The learn doc
Share
Explore
The learn doc
Learn by watching

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.
⁠
This link can't be embedded.
⁠
⁠
Filter formula
When you want to look at just one part of your dataset, use Filter formula.
⁠
This link can't be embedded.
⁠
⁠
User formula
Create personalized user experiences in your doc with User formula.
⁠
This link can't be embedded.
⁠
⁠
thisRow formula
Extrapolate and summarize your data with thisRow formula. Think of it like Coda's alternative to Excel battleship coordinates.
⁠
This link can't be embedded.
⁠
⁠
Contains formula
Extract the information you need with Contains formula.
⁠
This link can't be embedded.
⁠
⁠
Concatenate formula
Concatenate is a formula that strings information together and shows you how to create dynamic subject lines, buttons, and messages.
⁠
This link can't be embedded.
⁠
⁠
If & SwitchIf formulas
Get results based on a certain set of criteria with If and SwitchIf formulas.
⁠
This link can't be embedded.
⁠
⁠
FormulaMap
Apply the same action to a list of items in a table with FormulaMap.
⁠
This link can't be embedded.
⁠
⁠
⁠
Check your progress.
Here’s a view of your learning plan. What do you want to accomplish next?
Search
Task
Time commitment
Status
1
Watch the
Coda essentials
⁠
videos.
80 mins
Not Started
2
Subscribe to the Coda webinar channel at
crowdcast.io/coda-hq
⁠
.
1 min
Not Started
3
Bookmark the links in
Relevant reading
⁠
.
1 min
Not Started
4
Begin
Exercises
⁠
.
​
Not Started
No results from filter
1 hr 22 mins
⁠
Gallery
Share
 
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.