All Collections
Formulas
General formula info
Canvas formulas vs. column formulas
Canvas formulas vs. column formulas

What is the difference between a formula on the canvas and a formula in a column?

Updated over a week ago

Column formulas are formulas in a table that perform calculations on the table data. Canvas formulas are formulas embedded in the canvas. They can be freestanding and independent or tied to data from anywhere else in the document to help summarize or aggregate key data or metrics.

Let's see this in action. Let's say you're buying fruit for your four-person apartment and need to figure out how much each person owes. In the table of Fruit below, you can use the column formula

=[Price/Pound] * Pounds


to calculate total cost per fruit by multiplying the Price/Pound and Pounds column values:

Then, you can then use a formula on the canvas

=Fruit.Cost.Sum()/4


to obtain a cost per each person by dividing the total cost by four:

Now, we have the table for a deeper look at data, but a handy shortcut to the most important question we have on the canvas as well.

You can find an overview of Coda's formula language here and a full list of Coda's formulas here

Did this answer your question?