Why teams use it
The failure no view shows you
Smartsheet has no view that compares a column’s cells against each other, so a hand-typed value sitting where a formula should be looks exactly like a calculated result. The scan groups each column by the formula text its cells carry and reports the odd rows out by row number.
Tells you which columns to make permanent
A column where every filled cell carries the same formula but the column itself is not a column formula is one right-click from being safe — and until it is, every row added tomorrow comes in empty. Those columns are listed separately.
Checks the size before it reads the sheet
This scan reads every row, so it checks the row count first and reads up to 5,000 rows. A larger sheet is reported as too large rather than half-scanned, because a column read halfway through cannot tell you what the whole column agrees on.
How it works
Pick one sheet
The scan reads every row and cell of the sheet you choose, so it runs on one sheet at a time. No formula, column or cell is changed.
Read the drifted columns first
Each row shows how many cells agree on a formula, how many do not, and the row numbers of the ones that disagree — the numbers you type into Smartsheet to get to the cell.
Fix it, then convert the column
Put the shared formula back in the rows listed, then right-click the column header and choose Convert to Column Formula so the column cannot drift again.
Frequently asked questions
How do I find which cells in a Smartsheet column are missing their formula?
Not natively — Smartsheet shows a formula by clicking into the cell holding it, one cell at a time, so a column of 500 rows means 500 clicks. This scan reads every cell of one sheet, groups each column by the exact formula text its cells hold, and reports the columns where a clear majority share one formula and the rest do not, naming the odd rows by row number.
What counts as the same formula?
The exact formula text. That is the right comparison because of @row: a correct column-consistent formula such as =[Qty]@row * [Price]@row is textually identical on every row, so cells that agree really do read as identical. A formula written with an absolute reference genuinely differs from row to row, and the scan will honestly report that the column has no shared formula rather than calling it drift.
Will a parent rollup row be reported as drift?
No. A parent row in a hierarchy routinely holds a different formula from its children on purpose — =SUM(CHILDREN()) against a per-row calculation — so parent rows are left out of the comparison and counted separately. Reporting them would be this scan’s biggest source of false alarms.
Why is there a row limit when the other formula audit has none?
Because they read different things. The column formula audit reads column definitions, which cost the same on a sheet of nine rows as on one of twenty thousand, so it can cover a whole account. This scan has to read every row and every cell to compare them, so it is bounded: it checks the row count first and reads up to 5,000 rows. Over that it tells you the sheet is too large and scans nothing, rather than returning a partial result that would look like a clean one.
Does this show my conditional formatting rules?
It shows where they are landing, not what they say. Smartsheet’s API returns the formatting a conditional rule produced for a cell, not the rule or its condition, so the scan reports how many cells in each column a conditional format is applied to and how many distinct formats those are. The rules themselves are in Conditional Formatting on the sheet’s toolbar.
Can this fix a formula for me?
No. The scan is read-only: it reads cells and never writes one. It also never reads a cell’s value out into its report — a hand-typed override is reported as a row number and the fact that it is hardcoded, so you open the sheet to see what was typed.
Prefer to do it by hand first?
When a few rows of a Smartsheet column stop calculating, nothing flags it. Here is why cell formulas drift apart, and how to find the rows that disagree.
Why Some Rows of a Smartsheet Column Stopped Calculating →Ready to get started?
Connect your Smartsheet account and try it in minutes.
Connect Smartsheet to Start