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.



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


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