SHEET
Returns the sheet number of the referenced sheet
Syntax
SHEET([value])
Parameters
- value: Optional. The name of a sheet or a reference for which you want the sheet number. If omitted, returns the number of the sheet that contains the function
Example
=SHEET("Sheet2")