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: