Keep existing results, under Auto-run in the toolbar.
Rerun only what needs it
1
Turn on Keep existing results
Sits under Auto-run in the toolbar. With it on, a run only recomputes cells that are empty, out of date or errored.
2
Choose a scope instead
From a column’s run menu, pick Run empty or out-of-date rows for the same effect on demand. Or choose Force run all rows to recompute everything anyway.
Reuse an earlier answer
Two rows asking the same question, like the same name at the same company, can share one answer instead of paying twice. This only applies while that answer is still fresh, and only within your own workspace. A row where nothing was found is never reused, so it is tried again in full every time.Good to know
Does Keep existing results ever overwrite an answer I already have?
Does Keep existing results ever overwrite an answer I already have?
No. It skips any cell that already holds a value, whether that value came from a run or from you correcting it by hand.
How do I force a brand new answer instead of a cached one?
How do I force a brand new answer instead of a cached one?
Force run all rows always recomputes the cell, but an identical question asked recently may still return the same answer. Change an input, even slightly, to guarantee a fresh lookup.
Does a failed cell ever come back for free?
Does a failed cell ever come back for free?
Yes. Retry failed rows only touches cells that errored or are missing, so nothing that already succeeded is recomputed or charged again.
What counts as out of date?
What counts as out of date?
A cell whose inputs changed since it last ran. It keeps showing its old answer, marked stale, until the column runs again.
Next steps
Run columns
Run a column yourself, or let it run by itself.
Improve your fill rate
Better inputs fill more rows than more runs do.