Skip to content
Google Sheets

SHEET function in Google Sheets

Returns the sheet number of the specified sheet or other reference. .

=SHEET(value)

SHEET syntax and parameters

One argument, zero required.

  • valueanyOptional

    [ OPTIONAL ] - The value to be verified as a sheet name or other reference. If you don’t include an argument, the function will return the sheet number of the sheet where the formula is located.

SHEET examples

Formulas you'll actually reuse.

  1. The position of the current tab in the workbook:

    =SHEET()

    Result3

  2. The position of a tab by name — handy for tab-order checks:

    =SHEET("Budget")

    Result2

SHEET in Excel

Same name — your formula ports as-is.

Try SHEET in the playground

Edit the example — nothing to install.

Preloaded with the SHEET formula from Example 1 — change anything and watch it respond.

Loading the editor…

SHEET errors

What they mean — and the fixes.

  • #N/A

    No sheet has that name, or the reference isn't valid — names are case-insensitive but must otherwise match exactly.

Related functions

More ways Google Sheets gets this done.