Zoho Sheet SHEET: Find a reference’s worksheet position

=SHEET([cell_ref])

The official syntax line shows a cell reference, and its argument description explicitly permits omission. With a reference, the result concerns that reference’s sheet; without one, it concerns the formula’s own sheet. Zoho says the reference cannot contain more than one cell range. Official SHEET reference.

A sheet number is an ordinal position, not a name, a count of all sheets, or an immutable identifier. It also does not report the referenced cell’s row or column.

Use a demonstration workbook with exactly these three sheets in this order:

1. Inputs
2. Calc
3. Report

On Calc, place the formulas below in separate cells. The reference spelling follows Zoho’s documented dot-separated sheet examples:

These numbers follow the explicit scenario; they are not observations from an actual Zoho workbook. If your workbook has additional sheets or a different order, reconstruct the expected positions before comparing results.

No cell value is required to reason about the ordinal. A1 versus A10 changes the location inside the sheet, but both references point to the same worksheet. Conversely, identical A1 values on two different sheets do not make their sheet numbers equal.

Now consider the order Report, Inputs, Calc. In that scenario, =SHEET(Report.A10) refers to position 1, and a =SHEET() formula on Calc concerns position 3. The sheet names remain recognizable while their positions change.

This is why saving an ordinal as a permanent record identifier is fragile. A later inserted or rearranged tab can make the same ordinal describe a different sheet. The example explains the intended contextual result; it does not claim that a live reordering/recalculation sequence was tested here.

Suppose a template expects Report to be the third tab. Put =SHEET(Report.A10) on the control sheet and compare its displayed number with the template’s intended order. If it differs, inspect tab organization rather than changing the data in Report.A10: the content of that cell is not the problem the check is asking about.

For a more useful audit, keep the readable sheet name next to the ordinal and document the expected order. A number alone is poor context for someone reviewing a copied workbook. This check is about workbook structure, not whether the report’s calculations or access permissions are correct.

Do not use SHEET to count rows. ROW returns a row position, while COLUMN concerns a column. CELL has a documented "SHEET" information selector, but that does not make the whole CELL function an alias for SHEET.

Use a real cell reference rather than an assumed sheet-name string. The help also shows a defined-name example; to reproduce such a case, the name’s actual reference and workbook order would both need to be specified. An unexplained name such as Sales_data is not enough to predict a result.

Zoho’s generic error table includes invalid names, types and references. The article does not establish exact behavior for every multi-area, deleted-sheet, external-workbook or quoted-name case. In particular, do not infer that =SHEET("Report") is interchangeable with =SHEET(Report.A10) from another spreadsheet’s contract. Official reference and limits.

The simple names here avoid spaces and punctuation. More complex sheet-name quoting should be checked with Zoho’s own reference entry behavior rather than invented syntax.

The rolling official page was checked October 18, 2026. Examples are conditional workbook-context reasoning with complete sheet order and formula location. No actual workbook was created, reordered or executed for this guide. Introduction version, mobile parity and historical retirement status are not established by these sources.