SHEET
Returns the sheet number of the referenced sheet.
InformationInformation & Auditing
What it does
Returns the index number of a sheet.
Syntax
SHEET([value])
Arguments
value(text) — Sheet name or reference (optional).
Examples
Sheet Number
Get sheet index.
FORMULA
=SHEET()
RESULT
1
SAMPLE DATA
| A | |
|---|---|
| 1 | Info |
| 2 | (Sheet1) |