Skip to content

Collective Tools' new services are launching in August!   Sign up for early access.

Documentation › Calc

Formulas and functions

You can use formulas in Calc to calculate values based on data in the table.

  1. Click the cell where you want to add a formula.
  2. Type an equals sign = to start writing a formula, for example =SUM($amount).
  3. Press Enter to confirm.

In Grist, formulas apply to the entire column, not just a single cell. You can use Python syntax in formulas.

Click a column header and select Set formula to edit an existing column formula.

Built on Grist: Manual, Forum