Auto-run or run columns yourself
Turn on Auto-run in the toolbar and a column recomputes by itself whenever its inputs change or rows arrive. Its own description says exactly that: it runs cells by themselves when their inputs change or rows arrive. With Auto-run on, decide what happens to cells that already have an answer. Turn on Keep existing results and only errored, empty, or new cells run again, so a run never re-spends credits on a cell that already succeeded. With Auto-run off, a column only computes when you ask it to. Open a column’s header menu and select Run column to see your options, including:- Run first 10 rows, a quick check before committing to the whole table
- Run empty or out-of-date rows, to fill in what is missing
- Retry failed rows, to try again on cells that errored
- Force run all rows, which recomputes even cells that already hold answers
- Choose rows to run…, to pick specific rows
Watch and stop runs
The counter next to 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, and Recurring refreshes, the columns set to run again on a standing schedule. While anything is active, Stop all runs halts every run on the table at once. The toolbar also carries a standalone Stop button. It is disabled until something is running, so it teaches you where the brake is before you ever need it. Cells already computing finish; the rest are skipped.Run conditions
Not every row needs a column to run. Open a column’s editor, expand Run conditions, and turn on Only run some rows to build a condition, such as running only where Employees is greater than 50 and Country is US. Add up to eight conditions joined by and or or, or describe what you want and select Generate to have Oneprofile write the condition for you.Rows that don’t match a run condition are cleared and marked Skipped rather than left holding a stale answer.
Views
The view switcher sits in the toolbar next to the run controls. Default view is the table as everyone shares it: no sort, no filters, the shared column visibility. Oneprofile also ships four built-in views:- All rows: every row and column, with no filters applied
- Errored rows: rows where a cell failed to compute
- Fully computed rows: rows where nothing failed
- Non-formula columns: hide every computed column
1
Set up the table the way you want it
Adjust the sort, add filters, or hide the columns you don’t need.
2
Open the view switcher and select Save current as view…
Name it. It now appears in the view list for anyone with access to the table.