SHEET Function in Google Sheets: Formula, Examples & Troubleshooting
Find a tab position with SHEET in Google Sheets. Compare omitted arguments, sheet names and references, and track reorder-sensitive checks.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: SHEET returns the sheet number for a named sheet or reference. =SHEET() returns the number of the sheet containing the formula. The result describes tab order, not a permanent identifier.
Verification: NOT_TESTED_IN_GOOGLE_SHEETS. Google’s help and release announcement were reviewed October 17, 2026. The tab-order examples below were independently modeled; no live workbook was rearranged.
Syntax and omitted argument
=SHEET(value)
Google marks value optional. You can omit it, supply a sheet name, or supply a reference. The help also documents references to a table or range. This guide uses ordinary sheet/cell references to keep the setup explicit.
Without an argument, SHEET identifies the tab where the formula is located. With an invalid sheet name or reference, Google says it returns an error; the reviewed source does not specify a universal exact error token. Google SHEET reference.
Example: map a four-tab workbook
Prepare these four tabs in this left-to-right order:
- Setup
- Data
- Summary
- Archive
On Summary, enter the following formulas into separate cells:
| Formula | Expected result for this order |
|---|---|
=SHEET() |
3 |
=SHEET(Data!A1) |
2 |
=SHEET("Archive") |
4 |
=SHEET(Setup!A1) |
1 |
The string "Archive" is a sheet name, not a path or file identifier. The unquoted expression Data!A1 is a cell reference. Both forms identify a sheet through different kinds of input.
Use the exact current name in a string-based example. If a tab is named Monthly Data, a cell reference is written with single quotes around the sheet name: =SHEET('Monthly Data'!A1). Those single quotes belong to reference syntax; a sheet-name text argument instead uses double quotes, as in =SHEET("Monthly Data").
Do not read the number from a tab’s visible name. A tab called Sheet99 can occupy the first position. The expected result follows its position, not the digits in its title.
What changes when tabs move?
Now consider moving Archive to the first position. The modeled order becomes Archive, Setup, Data, Summary. The expected outputs change as follows:
| Formula on Summary | Before | After the modeled move |
|---|---|---|
=SHEET() |
3 | 4 |
=SHEET(Data!A1) |
2 | 3 |
=SHEET("Archive") |
4 | 1 |
=SHEET(Setup!A1) |
1 | 2 |
Google’s release announcement specifically says these structural functions recalculate when sheets are added, deleted, moved, or renamed. That makes SHEET useful for order-sensitive checks, but unsuitable as a permanent tab ID stored in an external system. Google’s February 2026 announcement.
Advanced use: warn when a report is before its input tab
If a reporting convention requires Data to precede Summary, use:
=IF(SHEET(Data!A1)<SHEET(Summary!A1),"Order OK","Review tab order")
In the original four-tab layout, 2 < 3, so the expected label is Order OK. If Summary is moved before Data, the comparison becomes false and the expected label is Review tab order.
This checks a presentation convention. It does not prove that Summary’s formulas reference Data correctly or that Data is complete. Keep structural checks separate from data-quality and arithmetic checks.
For another layout rule, =SHEET(Summary!A1)-SHEET(Data!A1) is expected to be 1 when Summary is immediately after Data in the original layout. The difference is an order-distance measure. It is not a count of rows, data records, or populated cells.
Troubleshooting
- The result changes after moving a tab: That is consistent with a position-based function and Google’s documented structural recalculation.
- A quoted name fails after a rename: Compare the literal text with the current tab name. This guide does not assume that manually written name strings are automatically rewritten.
- A copied formula reports a different tab: With no argument, SHEET identifies the formula’s own sheet. Use an explicit reference if the intended target should remain a particular tab.
- You need the tab name rather than its number: That is a different question; Google’s CELL function documents a
sheetselector for a referenced cell’s name. - You need the workbook’s sheet count: Do not interpret SHEET’s position result as that count. A formula on the second tab can return 2 in a workbook containing many more tabs.
- A range or table reference fails: Verify the reference’s validity and exact current name before replacing it with a guessed number.
The reviewed sources do not settle every hidden-sheet, external-reference, or malformed-reference edge case. No such behavior or exact native error string is asserted here.
Release and compatibility notes
Google announced SHEET on February 23, 2026, with gradual rollout of up to 15 days starting that date, for Workspace customers and personal Google accounts. This establishes an announced rollout window, not the exact first availability time for a particular account. No retirement or last-working version was established.
The guide concerns Google’s documented implementation. It does not transfer another spreadsheet product’s rules for special sheet types or reference syntax to Sheets.