ReferenceFunctionsInformation Functions

SHEETS

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

Summary

With no argument, returns the active workbook sheet count. With a reference, returns the number of sheets covered by that reference.

Returns the number of sheets in the workbook or covered by a 3D reference.

Examples

Workbook sheet count

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

1

Single-sheet reference count

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

1

FAQ

What does SHEETS return for ordinary references?

Ordinary references cover one sheet, so the result is 1.

Runtime metadata

Category

Information

Signature

SHEETS(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

SHEET

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

T

Returns text when input is text, otherwise returns empty text.

On this page

Summary Examples Related functions FAQ What does SHEETS return for ordinary references?Runtime metadata