← All tools

Find the Cross-Sheet References That Stopped Resolving

Smartsheet reports a reference’s status one sheet at a time, one reference at a time. This checks up to 1,000 accessible sheets per run and lists the references it reports as unresolvable, so you find them before the formulas reading through them start erroring.

Connect Smartsheet to Start
Free · Read-only · Secure Smartsheet OAuth · Disconnect anytime
Requires a Smartsheet plan with API access — Business, Enterprise or Advanced Work Management.

Why teams use it

Every reference in one list

Review the cross-sheet references returned for up to 1,000 accessible sheets per run, each with the status Smartsheet reported and the source sheet it reads.

Separates faults from transient states

Smartsheet documents some statuses as temporary — a reference it has not validated yet, or one paused for maintenance. Those are reported apart from the four statuses documented as unresolvable, so the list worth acting on stays worth acting on.

Find what read a deleted sheet

Search by source sheet to see which of your sheets referenced it. A source that is not among your own sheets is reported as such rather than left blank.

How it works

Run the scan

Check up to 1,000 accessible sheets for cross-sheet references. Review coverage and any sheets that could not be read. No reference is created, repointed or deleted.

Read the broken ones first

The list opens filtered to the statuses Smartsheet documents as unresolvable, with the reference name as it appears between braces in your formulas.

Fix them in Smartsheet

Open the sheet, find the formula using that reference name, and edit the range it points at. Export the audit as CSV to track the work or hand it on.

Frequently asked questions

How do I find broken cross-sheet references in Smartsheet?

Smartsheet shows a reference’s status in the reference manager on one sheet at a time. This audit checks up to 1,000 accessible sheets per run and lists each reference with the status the API returned, so the unresolvable ones can be reviewed together. Check the scan’s coverage and errors as well as its findings.

Why do my Smartsheet formulas show #REF?

Because the cross-sheet reference the formula reads through can no longer be resolved — but #REF is only one of several errors that can mean this, and Smartsheet documents each separately. #REF is a formula referencing a cell that no longer exists, after a row or column was deleted. #INVALID REF is a name in curly braces that matches no existing cross-sheet reference. #PERMISSION ERROR is nobody holding the required access to both sheets. #CIRCULAR REFERENCE is a formula that refers back to itself. #BLOCKED is a formula whose referenced cell already contains an error. The audit reports the status Smartsheet returned for each reference — BROKEN, NOT_SHARED, CIRCULAR or BLOCKED — so you can tell which of these you are looking at.

Does a reference with an unvalidated or disabled status mean something is broken?

No. Smartsheet documents INVALID/UNKNOWN as a reference that is new and has not been validated yet, and DISABLED as updates being temporarily paused for maintenance. Neither is a fault in your sheet, so the audit counts and lists them separately from the unresolvable ones.

Can this repair a broken reference for me?

No. The audit is read-only: it reports what Smartsheet returned and never creates, repoints or deletes a reference. Repointing a reference is done in Smartsheet, on the sheet holding the formula.

Prefer to do it by hand first?

What #REF, #INVALID REF and #PERMISSION ERROR mean in a Smartsheet formula, how to read a cross-sheet reference’s status in the reference manager, and how to fix it.

Why Smartsheet Formulas Show #REF →

Ready to get started?

Connect your Smartsheet account and try it in minutes.

Connect Smartsheet to Start