Why teams use it
The inventory the product does not show
Smartsheet shows a column formula one column at a time, behind a cell, on one sheet. This lists the formulas returned for up to 1,000 accessible sheets per run, each with its sheet, its column and the column’s type and position.
Search the formula text itself
Filter across every formula at once to find the ones using a given function or reading a given range — the closest thing available to asking what references a column.
Reads no rows, so row count does not matter
The scan reads each sheet’s column definitions, not its data. A sheet near Smartsheet’s 20,000-row maximum costs the same to check as a sheet of nine rows, and no cell value is read or stored.
How it works
Run the scan
Check up to 1,000 accessible sheets for column formulas. Review coverage and any sheets that could not be read. No formula, column or cell is changed.
Start with the cross-sheet ones
The list opens filtered to formulas that read another sheet through a braced reference — the ones that can break because something changed elsewhere.
Edit them in Smartsheet
Open the sheet, right-click the column header and choose Edit Column Formula. Export the audit as CSV to keep the inventory or hand it on.
Frequently asked questions
Can I see a list of all formulas in Smartsheet?
Not natively — Smartsheet shows a formula by clicking into the cell holding it. This audit lists the column formulas returned for up to 1,000 accessible sheets per run, each with the sheet and column it sits on. It covers column formulas, which are the ones that own a whole column; formulas written into individual cells are not included, because reading those means reading every row of every sheet. Check the scan’s coverage and errors as well as its findings.
What is a column formula in Smartsheet?
A formula applied to an entire column rather than to one cell, so Smartsheet uses it for every row in that column including rows added later. It is set by right-clicking the column header and choosing Convert to Column Formula, and it is the reason a column keeps calculating correctly after you stop maintaining it by hand.
How do I find which of my formulas read another sheet?
A formula that reads another sheet names a cross-sheet reference between curly braces, as in =SUMIF({Budget Range 1}, …). The audit pulls those names out of each formula and lists them, and opens filtered to the formulas that have one. Whether a given reference still resolves is reported by the separate cross-sheet reference audit.
Does this include formulas in individual cells?
No. Per-cell formulas are only returned by fetching a sheet’s rows, which on a large account means reading every cell of every sheet. This audit deliberately reads column definitions only, so it stays cheap and reads no cell values. A column where most rows share a formula and a few were overwritten by hand is not something it can detect.
Can this change or fix a formula for me?
No. The audit is read-only, and Smartsheet’s API has no endpoint that sets a column formula, so there is nothing to apply. Editing a column formula is done in Smartsheet, on the sheet holding it.
Prefer to do it by hand first?
Smartsheet shows a formula one cell at a time. Here is how column formulas work, why there is no list of them, and how to inventory them across sheets.
How to See Every Column Formula in Smartsheet →Ready to get started?
Connect your Smartsheet account and try it in minutes.
Connect Smartsheet to Start