Syntax
SHEET([value])
| Parameter | Description |
|---|---|
| [value] | (Optional.) Parameter of the SHEET function. |
Examples
Current sheet number
Formula
=SHEET()
Returns the position number of the current sheet. If you're on the third tab, returns 3.
Sheet number of named range
Formula
=SHEET(SalesData)
Returns the sheet number where the named range SalesData is defined. Useful in workbooks with many named ranges across sheets.
Common Errors
#N/A
Occurs if the sheet reference is invalid or the named range doesn't exist.
#REF!
Occurs when referencing a deleted sheet.
Tips
Zero-indexed in some apps
In most spreadsheet apps, sheets are 1-indexed (first sheet = 1). Verify in your specific application.
Dynamic sheet formulas
Combine SHEET with other functions to build formulas that adapt based on which sheet they're on — useful for template sheets.
Not widely supported
SHEET is available in Excel 2013+ and some other apps, but not all spreadsheet applications support it.
Try SHEET in Viztab
Import your data and use SHEET with 370+ other formulas. No signup required.
Open Viztab