Formualizer Docs
ReferenceFunctionsInformation Functions

SHEET

Returns the 1-based sheet index for the current sheet or a reference.

Summary

With no argument, returns the index of the sheet containing the formula. With a reference or sheet-name text argument, returns that sheet's index.

Returns the 1-based sheet index for the current sheet or a reference.

Examples

Current sheet index
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1
Referenced sheet index
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1

FAQ

Are sheet indexes 0-based?

No. SHEET returns Excel-style 1-based sheet indexes.

Runtime metadata

Category

Information

Signature

SHEET(arg1…: Any)

This function accepts a repeating argument pattern (min args: 0).

Arity

min 0, max variadic

Arguments

arg1

Any · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/info.rs

NA

NA: Returns the `#N/A` error value.

SHEETS

Returns the number of sheets in the workbook or reference span.

On this page

SummaryExamplesRelated functionsFAQAre sheet indexes 0-based?Runtime metadata