Share
Explore

A year of formula fitness

Grow your skills, one component at a time.
Ever want to get better at your Coda formula skills? We do too! That's why we host our formula fitness series for a deep dive into a formula component. Use the table below to
watch
past formula fitness sessions and open the
exercise doc
to practice for yourself.
Formula Component
Level of difficulty
What is it?
Watch the webinar
Open the doc
1
Nth
Learn how to return the Nth item in a list (e.g. if n=4, return the 4th item)
Watch recording
Exercise doc
2
Splice
Learn how to remove items and insert new items in a list
Watch recording
Exercise doc
3
Slice
Learn how to pull part of a list or a selection of text
Watch recording
Exercise doc
4
Contains, Matches, and Find
Learn how to find needles in a data haystack via near and exact matches
Watch recording
Exercise doc
5
Concatenate
Learn how to combine expressions and data
Watch recording
Exercise doc
6
Switch and SwitchIf
Learn how to get values conditionally
Watch recording
Exercise doc
7
isBlank/isNotBlank
Learn how to check if a value is or is not blank
Watch recording
Exercise doc
8
User and Time
Learn how to incorporate users in your doc or time values in formulas
Watch recording
Exercise doc
9
Data Types
Learn about different types of data you can access formulaicly
Watch recording
Exercise doc
10
Filter
Learn how to get a list of values that match your filter conditions
Watch recording
Exercise doc
11
Random
Learn how to select a random item or random integer
Watch recording
Exercise doc
12
Cross-doc
Learn how to use formulas to update or pull information from other docs
Watch recording
Exercise doc
13
ListCombine
Learn how to merge and flatten a list
Watch recording
Exercise doc
14
First
Learn how to get the first value from a list
Watch recording
Exercise doc
15
Last
Learn how to get the last value from a list
Watch recording
Exercise doc
16
Lookup
Learn how to filter for specific rows in your data
Watch recording
Exercise doc
17
List
Learn how to check a list for values from another list
Watch recording
Exercise doc
18
FormulaMap
Learn how to run a formula over every item in a list
Watch recording
Exercise doc
19
WithName
Learn how to name a value so you can reference it in a formula
Watch recording
Exercise doc
There are no rows in this table
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.