Skip to content
Formula Chips
Share
Explore

Formula Chips

This is a Coda formula chip
Chips-Project-Full.png
Formula chips represent some sort of data or information within your doc, and they give you clues about what that data is and where it is coming from. Formula chips are absolutely essential to writing complex, clean, and efficient formulas. Let’s dive in to learn about their unique parts.
This is what makes up a chip
Each formula chip has the following three properties
Icon
Color
Words
Click on any of the arrows below to expand and learn more
Icon
The icon on a formula chip is arguably the most important piece of information you should be paying attention to when building formulas. Icons tell you what type of data the chip itself holds
Here is a list of all the possible icon types you may come across and what types of data they correspond to
Chips-Action-Multiple-Icon-orange.png
List of Actions
Chips-Action-Single-Icon-orange.png
Action
Chips-Boolean-Multiple-Icon-orange.png
List of Boolean Values
Chips-Boolean-Single-Icon-orange.png
Boolean Value
Chips-Currency-Multiple-Icon-orange.png
List of currency
Chips-Currency-Single-Icon-orange.png
Currency
Chips-DateTime-Multiple-Icon-orange.png
List of dates
Chips-DateTime-Single-Icon-orange.png
Date
Chips-Duration-Multiple-Icon-orange.png
List of durations
Chips-Duration-Single-Icon-orange.png
Duration
Chips-Frame-Single-Icon-orange.png
Table
Chips-Image-Multiple-Icon-orange.png
List of images
Chips-Image-Single-Icon-orange.png
Image
Chips-Number-Multiple-Icon-orange.png
List of numbers
Chips-Number-Single-Icon-orange.png
Number
Chips-Percent-Multiple-Icon-orange.png
List of percentages
Chips-Percent-Single-Icon-orange.png
Percent
Chips-Row-Multiple-Icon-orange.png
List of row-values
Chips-Row-Single-Icon-orange.png
Row-value
Chips-Text-Multiple-Icon-orange.png
List of text
Chips-Text-Single-Icon-orange.png
Text
Chips-URL-Multiple-Icon-orange.png
List of URLs
Chips-URL-Single-Icon-orange.png
URL
Chips-User-Multiple-Icon-orange.png
List of people
Chips-User-Single-Icon-orange.png
People
The most important thing to notice when looking at a formula chip is whether or not that chip is holding a single value, or a list of values.
For the most part, Coda adds a shadow that makes it looks like two of the single values stacked together as seen below
image.png
Notice though, that because the formula chip indicates it is a list we must use list operators to find out what is inside the list. For example, if you wanted to know if you had a $50 expense in your table:
Color
The color of a chip shows you where the data is sourced from. Meaning, if everything is green (like in this screenshot below), all the data is coming from the same table
image.png
The moment you see a second, or third, or fourth color, this is your clue that this data is coming from a different source. Take for example this formula:
image.png
This formula has both green and pink chips. The green color indicates that each one of those data types is connected to the same source, which in this case is a table called Tasks by chips. The Pink chip indicates a different source, which in this case is a control like this one: →
12/14/2022
Wording
Lastly, each chip has some words on it! The words refer the name given to the data whether that be the name of table, control, column, etc.

Chips-TasksbyChips-Full (1).png
This chip lets us know that it contains a list of date data specifically from the Due Date column inside of a table called Tasks by chips.

Formula Chip Quiz
Try your hand at this quick formula chip quiz! Determine whether the icon indicates the chip is a list or a single value. Then select what data type it holds!

Icon
List
Single Value
Chip Value Type
Icon
List
Single Value
Chip Value Type
1
Chips-Action-Multiple-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
2
Chips-Action-Single-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
3
Chips-Boolean-Multiple-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
4
Chips-Boolean-Single-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
5
Chips-Currency-Multiple-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
6
Chips-Currency-Single-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
7
Chips-DateTime-Multiple-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
8
Chips-DateTime-Single-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
9
Chips-Duration-Multiple-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
10
Chips-Duration-Single-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
11
Chips-Frame-Single-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
12
Chips-Image-Multiple-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
13
Chips-Image-Single-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
14
Chips-Number-Multiple-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
15
Chips-Number-Single-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
16
Chips-Percent-Multiple-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
17
Chips-Percent-Single-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
18
Chips-Row-Multiple-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
19
Chips-Row-Single-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
20
Chips-Text-Multiple-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
21
Chips-Text-Single-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
22
Chips-URL-Multiple-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
23
Chips-URL-Single-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
24
Chips-User-Multiple-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
25
Chips-User-Single-Icon-orange.png
facebook-like reaction, you have not reacted
facebook-like reaction, you have not reacted
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.