Cross-Sheet Reference

A named pointer to a column or range in another sheet. Created via the cross-sheet reference icon in the formula bar. Referenced in formulas using curly braces {Reference Name}.

Syntax

smartsheet-mastery

{Reference Name} — created via Insert > Reference Another Sheet

Example

smartsheet-mastery

// After creating reference named "Portfolio Status":
=COUNTIF({Portfolio Status}, "At Risk")
=SUMIF({Portfolio Dept}, "Engineering", {Portfolio Budget})
=VLOOKUP([ID]@row, {Employee Roster}, 3, false)