Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
SHEET
SHEET returns the index number of a worksheet within the workbook, counting from 1. With no argument it returns the index of the sheet containing the formula; with a cell reference or sheet name it returns that sheet's index. Use it to build dynamic cross-sheet references or to audit sheet ordering.
Excel
=SHEET()Google Sheets
=SHEET()✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Sheet Name | Sheet Number |
| Sheet1 | 1 |
| Sheet2 | 2 |
| Sheet3 | 3 |
=SHEET()→1
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Call SHEET() with no argument to get the index of the current sheet.
- 2Pass a cell reference or sheet name (e.g., =SHEET(Sheet2!A1)) to get that sheet's number.
- 3Use the result in INDIRECT or other formulas to dynamically reference sheets by their ordinal position.
Need a version for your data?
Try: “Get the tab number of the current sheet to use in a dynamic cross-sheet formula”