![](https://sanity-images.imgix.net/production/f50d5d9df2b224d6efec0892ab6bf562fb9d1c7f-2617x2617.png?w=1200&auto=format%2Ccompress)
How to read a formula
Formulas 101
17 lessons, 49 minutes
Learn how to decode a complex formula
The Coda Formula Language leaves clues to help you understand what’s going on. Let’s review the clues so you can decode any formula you come across.![](https://sanity-images.imgix.net/production/b915547103afe2714c62ef3334d96546013b1733-3840x2160.png?w=600&auto=format%2Ccompress)
UP NEXT
Dot operator explained
Lookup columns and the dot operator are a perfect pair in Coda. In Coda, the dot operator is about how you get more information out of your lookup columns. See how to use the dot operator in your Coda lookup columns.
Next lessonFormulas 101
A comprehensive introduction to the Coda formula language allowing to unlock to power of working with data in Coda.
17 lessons, 49 minutes total
1
![](https://sanity-images.imgix.net/production/096772f6a63bf80323a6e14f6decacf6932b39f3-3840x2160.png?w=200&auto=format%2Ccompress)
Welcome to Formulas 101
0:52
2
![](https://sanity-images.imgix.net/production/997b4b52a148be1f03ad22eb44445e905c71d3f6-3840x2160.png?w=200&auto=format%2Ccompress)
The Coda formula language
5:50
3
![](https://sanity-images.imgix.net/production/d89cef3d0cc4c108f62dfaf57789706553c5e344-3840x2160.png?w=200&auto=format%2Ccompress)
What makes Coda's formulas different?
4:16
4
![](https://sanity-images.imgix.net/production/8dffc72cc1a251b8aca132e9104994a0d1e0d901-3840x2160.png?w=200&auto=format%2Ccompress)
How to write formulas
4:39
![](https://sanity-images.imgix.net/production/9cea2d22643718503fc7410a72d64b0d1e78188f-3840x2160.png?w=200&auto=format%2Ccompress)
How to read a formula
1:32
6
![](https://sanity-images.imgix.net/production/b915547103afe2714c62ef3334d96546013b1733-3840x2160.png?w=200&auto=format%2Ccompress)
Dot operator explained
1:17
7
![](https://sanity-images.imgix.net/production/8d7bd3d5b86be79664d20f1e5eb856a2a3be442c-3840x2160.png?w=200&auto=format%2Ccompress)
Filter formula
3:05
8
![](https://sanity-images.imgix.net/production/749a751713593d5ff1cf9149e1c33ee60a074524-3840x2160.png?w=200&auto=format%2Ccompress)
thisRow formula
1:42
9
![](https://sanity-images.imgix.net/production/5eaf08150bd551e0801fc170f2db9d868de4b163-3840x2160.png?w=200&auto=format%2Ccompress)
User formula
2:54
10
![](https://sanity-images.imgix.net/production/41d0da0fe639e30d3a360dbad1679fe86e06dc8f-3840x2160.png?w=200&auto=format%2Ccompress)
Concatenate and compose
2:13
11
![](https://sanity-images.imgix.net/production/71ac527fd77c0bce9b9725bccfa5443e923a6cdf-3840x2160.png?w=200&auto=format%2Ccompress)
Contains and Matches formulas
3:31
12
![](https://sanity-images.imgix.net/production/c7d202a42efedb6b07e31b53ec34abc660c729b8-3840x2160.png?w=200&auto=format%2Ccompress)
If and SwitchIf formulas
4:16
13
![](https://sanity-images.imgix.net/production/457eb1c29a24b0bb580a436ae01cb2c574199fb0-3840x2160.png?w=200&auto=format%2Ccompress)
Formulas and text
2:03
14
![](https://sanity-images.imgix.net/production/81110d30c5d78c6281f4c9018bc0d625aaf706a2-3840x2160.png?w=200&auto=format%2Ccompress)
Using the formula editor
1:18
15
![](https://sanity-images.imgix.net/production/d08186b9b8a2d2a05bbe5839d324d2887b8054ea-3840x2160.png?w=200&auto=format%2Ccompress)
Troubleshooting formulas
5:48
16
![](https://sanity-images.imgix.net/production/74c3e33d33d078202b2c3b4a48fa95970c194724-3840x2160.png?w=200&auto=format%2Ccompress)
Editing formulas
0:25
17
![](https://sanity-images.imgix.net/production/ce4f1a589e6488d94e6e0a32bebe0590d896371c-3840x2160.png?w=200&auto=format%2Ccompress)
Build a dashboard
3:56
Was this helpful?