Check Sheet Logo
Check Sheet

SHEET

The SHEET function returns the numeric position of a specified sheet, table, or range within a spreadsheet. It is commonly used to identify where a reference appears in workbook order or to make formulas aware of sheet positions.

Usage

Use the SHEET formula with the syntax shown below, it has 1 optional parameter:

=SHEET([value])
Parameters:
  1. value (optional):
    An optional sheet name, table name, or reference to check. If omitted, the function returns the sheet number of the sheet containing the formula.

Examples

Here are a few example use cases that explain how to use the SHEET formula in Google Sheets.

Find the current sheet number

Use SHEET without an argument to return the position of the sheet where the formula is entered.

Check a referenced sheet

Use SHEET with a sheet or range reference to identify the referenced sheet's position in the spreadsheet.

Support workbook navigation logic

Sheet numbers can be used in helper formulas that depend on the order of tabs in a spreadsheet.

Common Mistakes

SHEET not working? Here are some common mistakes people make when using the SHEET Google Sheets Formula:

Expecting the sheet name

SHEET returns a number, not text. It identifies the sheet's position rather than returning its name.

Providing an invalid reference

If the value is not a valid sheet name, table name, or reference, the function returns an error. Confirm that the referenced object exists.

Confusing position with sheet count

Use SHEET for one sheet's position and SHEETS for the total number of sheets.

Related Formulas

The following functions are similar to SHEET or are often used with it in a formula:

  • SHEETS

    The SHEETS function returns the number of sheets in a spreadsheet or in a referenced spreadsheet object. It is commonly used when a formula needs to count workbook tabs or validate that a referenced spreadsheet has the expected structure.

  • CELL

    The CELL formula returns information about the formatting, location, or contents of a cell. The type of information returned depends on the value of the info_type argument.

  • ISREF

    The ISREF formula is used to check if a value is a reference or not. It returns `TRUE` if the value is a reference and `FALSE` if it is not. This formula is commonly used in combination with other formulas that require a reference as input.

  • ISNUMBER

    The ISNUMBER formula is used to check if a given value is a number. It returns TRUE if the value is a number and FALSE if it is not. This formula is commonly used in data cleaning and validation to identify and remove non-numeric values or to ensure that a cell only contains a number.

Learn More

You can learn more about the SHEET Google Sheets function on Google Support.