The Formula Engine

Formula columns

Formula columns are computed columns that calculate a value for each row based on an expression. They're read-only — you write the formula, and Formula evaluates it for every row automatically.

Linked formula columns persist their values — results are saved with the file, available in Badge View, and included in exports. Unlinked formula columns compute on-the-fly for lighter storage.

Below the table, you can add footer rows with summary formulas. Each footer cell can have its own aggregation: =SUM(["Price"]), =AVERAGE(["Score"]), =COUNT(["Status"]). Footers recalculate automatically when filters are active.

Writing your first formula

Every formula starts with =. Reference columns with ["Column Name"] and formula columns with [="Formula Column"]. Use standard math operators (+, -, *, /) and comparisons (>, <, =, <>).

• → =["Price"] * 0.1 — Calculate 10% tax
• → =CONCAT(["First Name"], " ", ["Last Name"]) — Full name from parts
• → =IF(["Score"] > 80, "Pass", "Fail") — Conditional label
• → =ROUND(["Amount"] * 1.22, 2) — Round to 2 decimals
• → =DATEDIFF(["Start Date"], ["End Date"]) — Days between dates
• → =SUMIF(["Status"], "Active", ["Amount"]) — Sum only if condition

The formula popup editor provides real-time syntax validation, colored column references, and Ctrl+Arrow navigation between tokens. Errors are shown inline before you confirm.

Function reference

Formula includes 33 built-in functions across 9 categories.

• → Aggregation (6) — SUM, AVERAGE, MIN, MAX, COUNT, COUNTA
• → Conditional Aggregation (3) — SUMIF, COUNTIF, AVERAGEIF
• → Math (2) — ROUND, ABS
• → Conditional & Logic (6) — IF, IFERROR, AND, OR, NOT, ISBLANK
• → Statistical (5) — MEDIAN, STDEV, VARIANCE, MODE, COUNTBLANK
• → Lookup (2) — MAXROW, MINROW
• → Text (5) — CONCAT, LEN, UPPER, LOWER, TRIM
• → Date (6) — TODAY, NOW, YEAR, MONTH, DAY, DATEDIFF
• → Random (2) — RAND, RANDBETWEEN

Cross-table formulas

To use data from another table in your formulas, create a Lookup column (see Module 02) to import the value. Then reference the lookup column in your formula just like any other column.

For example: import "Client Revenue" via a lookup column, then write =["Invoice Amount"] / ["Client Revenue"] * 100 to calculate each invoice as a percentage of the client's total.

English & Italian syntax

Formula supports bilingual formula writing. You can write formulas in English or Italian — the parser understands both. Formulas are stored internally in English; when the app is set to Italian, function names display in Italian automatically.

All 33 functions have Italian translations: SUM → SOMMA, AVERAGE → MEDIA, IF → SE, COUNT → CONTA, and more. Switching the app language translates all displayed formulas instantly.

Example — same formula in both languages: =IF(SUM(["Price"]) > 1000, "High", "Low") becomes =SE(SOMMA(["Prezzo"]) > 1000, "Alto", "Basso").