Skip to main content
Computed columns fill their cells through runs: background work that spends credits. You choose when a run starts, which rows it covers, and when to stop it.
A table column's run menu open over the grid, listing Run first 10 rows, Run 50 empty or out-of-date rows, Retry failed rows, Force run all 50 rows and Choose rows to run. The three that recompute cells show an estimated credit total beside them; the other two show none.

A column's run menu.

​
Run a column yourself

Open a column’s header menu and choose Run column. An enrichment column offers:
  • Run first 10 rows, a quick check before the whole table
  • Run empty or out-of-date rows, to fill the gaps
  • Retry failed rows, to try again where cells errored
  • Force run all rows, which recomputes answers you already have
  • Choose rows to run…, to pick rows yourself
The credits show on Run first 10 rows, Run empty or out-of-date rows and Force run all rows. Tick rows in the grid and open Actions to run every enrichment column over just those rows. The cost shows beside it.

​
Let columns run by themselves

1

Turn on Auto-run

Auto-run sits in the toolbar. Columns then run cells by themselves when their inputs change or rows arrive.
2

Turn on Keep existing results

It sits under Auto-run. Only errored, empty or new cells run again.

​
Watch and stop runs

The counter beside Auto-run shows how many cells the table’s active runs still owe. Open it to see Scheduled column runs, each with its progress and a Cancel button. Stop all runs at the foot of that panel halts every run on the table. The status bar under the grid carries its own Stop.

​
Run only some rows

A column can carry a condition so it only runs on rows that qualify, and skips the rest at no cost. See Set a run condition.

​
Good to know

Auto-run decides whether a run starts by itself. Keep existing results decides whether that run overwrites answers you have already paid for. A run then never re-spends credits on a cell that already succeeded.With Auto-run off, a column fills its cells only when you run it.
An enrichment column’s Run conditions section carries its own Run automatically on new and changed rows checkbox.
Auto-run is a standing spend, not a one-off. It re-spends credits every time inputs change or rows are added.
Rows that do not match are cleared and marked Skipped, rather than left holding a stale answer from an earlier run.
Cells already computing finish. Everything the run had not started is skipped, and you can run the column again to pick them up.Stop in the status bar is greyed out until there is something to stop.
Each scheduled run shows how many of its cells are done. Under that it names failures, cells where nothing was found, and cells that were skipped, counted apart from one another.
A column can refresh itself on a schedule. See Schedule a re-run.
A function column offers Run all, Retry failed rows and Run first 10. An export column has its own two, covered on Export to a tool.
Run empty or out-of-date rows and Force run all rows name how many rows they cover once Oneprofile has counted them. On a 50 row table they read Run 50 empty or out-of-date rows and Force run all 50 rows.

​
Next steps

Views

Change what you are looking at without touching the data.

Set a run condition

Run a column only on the rows that qualify.

Schedule a re-run

Keep a column fresh on a schedule.

Enrichment columns

Add a column that fills itself in from outside data.