![](https://sanity-images.imgix.net/production/f50d5d9df2b224d6efec0892ab6bf562fb9d1c7f-2617x2617.png?w=1200&auto=format%2Ccompress)
Welcome to Formulas 101
Formulas 101
17 lessons, 50 minutes
- Structure of Coda formulas
- Use the five most valuable formulas
- Troubleshoot when things go wrong
- Recognize when you could use a formula in a doc
- Copy this companion doc. This is where you will do all of your practice activities.
- Be sure to log into Coda.
![](https://sanity-images.imgix.net/production/0c80b872978df719c1724f03ce22d02c14295abb-1920x1080.png?w=600&auto=format%2Ccompress)
UP NEXT
The Coda formula language
An overview of what to expect in the Formulas 101 course and a walkthrough of the companion doc.
Next lessonFormulas 101
A comprehensive introduction to the Coda formula language allowing to unlock to power of working with data in Coda.
17 lessons, 50 minutes total
![](https://sanity-images.imgix.net/production/54ec84186e708cc6713150b107a60d4be7307abc-1920x1080.png?w=200&auto=format%2Ccompress)
Welcome to Formulas 101
0:52
2
![](https://sanity-images.imgix.net/production/0c80b872978df719c1724f03ce22d02c14295abb-1920x1080.png?w=200&auto=format%2Ccompress)
The Coda formula language
5:50
3
![](https://sanity-images.imgix.net/production/4772538ddd862777450e0ee7294701f4cc41bc3f-1920x1080.png?w=200&auto=format%2Ccompress)
What makes it different?
4:16
4
![](https://sanity-images.imgix.net/production/0c80b872978df719c1724f03ce22d02c14295abb-1920x1080.png?w=200&auto=format%2Ccompress)
How to write formulas
5:50
5
![](https://sanity-images.imgix.net/production/11d0659135881e2e2068a4c0a10bc230b1406de0-3840x2160.png?w=200&auto=format%2Ccompress)
Tip: How to read a formula
1:32
6
![](https://sanity-images.imgix.net/production/20901762f475c2a4e70f18127848eba291ccae73-3840x2160.png?w=200&auto=format%2Ccompress)
Tip: Dot operator explained
1:17
7
![](https://sanity-images.imgix.net/production/c11e19ae8846aeca1663f8d103f14105710a9432-1920x1080.png?w=200&auto=format%2Ccompress)
Filter formula
3:05
8
![](https://sanity-images.imgix.net/production/66f1b4e938631cb97b9dc4a097e0c9245f7f0e6c-1920x1080.png?w=200&auto=format%2Ccompress)
thisRow formula
1:42
9
![](https://sanity-images.imgix.net/production/8b7369a4de0bed60b7ae642c6e929e8f89036e90-1920x1080.png?w=200&auto=format%2Ccompress)
User formula
2:54
10
![](https://sanity-images.imgix.net/production/fb9eed2e3622faf0f653e24ca76cafc6a4e75c02-1920x1080.png?w=200&auto=format%2Ccompress)
Concatenate and compose
2:13
11
![](https://sanity-images.imgix.net/production/b7e430e1f2ae26d1371a6d6668ae6b9e4c7b79c6-1920x1080.png?w=200&auto=format%2Ccompress)
Contains and Matches formulas
3:31
12
![](https://sanity-images.imgix.net/production/da262e55c34bf727adc32d30b88580bd46293105-1920x1080.png?w=200&auto=format%2Ccompress)
If and SwitchIf formulas
4:16
13
![](https://sanity-images.imgix.net/production/c52a9bbdf8b2d99d6cd691850c784189303d1436-1920x1080.png?w=200&auto=format%2Ccompress)
Tip: Formulas and text
2:03
14
![](https://sanity-images.imgix.net/production/b6c9aadc35b61eb78ca845a10c629547709337e2-1920x1080.png?w=200&auto=format%2Ccompress)
Tip: How to use the formula editor
1:18
15
![](https://sanity-images.imgix.net/production/235c14104b4f5f54eebf6a45f566115965d7b62e-1920x1080.png?w=200&auto=format%2Ccompress)
Troubleshooting formulas
5:48
16
![](https://sanity-images.imgix.net/production/45cb3b85ec1ecc75036d452b4883852d85d2789c-1920x1080.png?w=200&auto=format%2Ccompress)
Tip: How to edit formulas
0:25
17
![](https://sanity-images.imgix.net/production/6ec067c6d40938ec44fe8df97bdfb73b574bf579-1920x1080.png?w=200&auto=format%2Ccompress)
Build a dashboard
3:56
Was this helpful?