Formula
A formula column computes its value from other columns in the same row. It calls no provider, so it costs no credits, and it recomputes when its inputs change.
This is where scoring, flagging, cleaning and combining happen.
What it is for
| Job | Example |
|---|---|
| Score | Add points for headcount band, funding recency and role match into one number |
| Flag | qualified = true when the row passes every minimum |
| Normalize | Strip www. and paths off a URL to leave a clean domain |
| Combine | Join first name, company and a signal into one line of copy |
| Extract | Pull the domain out of an email, the year out of a date |
| Bucket | Turn a headcount number into SMB / Mid-market / Enterprise |
Add a formula column
- Click Add Action and choose the formula column
- Reference the columns you need as dynamic variables — type
/and pick the column - Run one row and read the output before running the column
- Run the column with ▶️ in the header
Because it is free, run it on the whole table — there is no reason to sample.
Formula Generator
You do not have to write the logic yourself. Formula Generator takes a plain-English description of the transformation and builds the formula column for you.
Describe the output, reference the source column, review what it generated, then run it.
Nulls are the thing that breaks formulas
A formula reading a column that has not populated yet does not error — it produces a value from an empty input, and that value looks like a real answer.
- Test every formula on a row where the input is empty, not just on rows where it worked
- A score built on missing inputs will score everything the same and nobody will notice
- If a flag has never come out false, it has not been tested
This matters most when the formula feeds a conditional formula — a gate reading a broken score passes or fails everything.
Formulas are free, so put them everywhere
The pattern that keeps a table cheap:
cheap columns → formula score → conditional gate → expensive columnsEverything left of the gate costs 0 or near 0. The formula is what makes the gate possible. See Credits for the arithmetic.
Where to next
- Conditional Formula — use a formula’s output to decide which rows an action runs on
- Formula Generator — write formulas in plain English
- Built-in Enrichments — free actions that split names, merge columns and parse JSON
- Score and gate the spend — a full scoring model built from free columns