QuantyDocs

Clean data with AI formulas

An import left you with amounts like "1 200,00 zł", names in inconsistent casing and a margin column that doesn't exist yet. Formulas fix all three deterministically — no tokens spent, no model in the loop at apply time — and the AI helps only with writing the formula itself.

What you need: a sheet with at least a few rows of messy data.

Step 1 — Open the Formula creator

Select the column you want to fill (or any cells in it) and open the Formula creator. It offers two starting points: write the formula yourself, or Ask AI for a formula in plain language.

Step 2 — Describe the transformation

Type what you want and click Generate:

Strip currency symbols and spaces from Amount and convert it to a number.

The AI drafts a formula that references your actual columns. Formula generation is the only step that uses AI; running the formula afterwards is free.

Step 3 — Check the live preview

The modal shows a Preview of the result computed against your real rows before anything is written. Invalid formulas simply report as invalid — nothing breaks, and nothing is saved until you apply.

Step 4 — Choose where it applies

  • Selected cells — a one-time fix for the rows you highlighted.
  • Whole column — the formula becomes the column's rule: it runs on every row now and for any new rows that arrive later.
  • Create new column… — put the result into a fresh Number or Text column, for example a computed Margin.

Step 5 — Edit inline with the formula bar

For quick math you can skip the modal. The Excel-style Formula bar above the grid accepts a value, or a formula when you start with =:

= row['Revenue'] - row['Cost']

Formulas entered here apply to the whole column. The function library covers Math, Text, Dates and Logic — sum, avg, round, concat, replace, split, daysbetween, ifelse, coalesce and some two dozen more.

Step 6 — Add totals and check the stats

Select a range to see Count / Sum / Avg / Min / Max in the selection stats bar. Turn on the Totals summary row for per-column aggregates — Sum, Average, Min, Max, Count numbers, Count filled, or a custom expression like =sum(col('Amount')).

Rules of the road

Formula results are written to cells with a full audit trail. Ground-truth-locked cells are skipped rather than overwritten, and File and Sub-sheet columns can't be used in formulas.

Where to go next