SHEET function

SHEET returns the sheet number of a reference or a string representing a sheet name. If you do not enter any parameters, the result is the sheet number of the spreadsheet containing the formula.

Syntax

SHEET(reference)

reference is optional and is the reference to a cell, an area, or a sheet name string.

Example

=SHEET(Sheet2!A1) returns 2 if Sheet2 is the second sheet in the spreadsheet document.