Is there a way to reference a sheet name in Numbers?

the "General Form" of a cell reference is:

<Sheet Name>::<Table Name>::<CELL>

If you have a sheet named "Sheet 1" that has two tables "Table 1" and "Table 2"

and another sheet name "Sheet 2" that has three table "Up", "Down" and "Data"

then a cell in Table 1 of Sheet 1 can refer to cell A3 or table Data on Sheet2 like this:

="Sheet 2::Data::A3"

to reference a range:

="Sheet 2::Data::A3:B6"

If you mean is there a way to use a formula to place the sheet name in a cell (the way you can in Excel using the CELL function) then the answer is no.

You can use AppleScript to reference the sheet name.

And of course your formulas can references cells in other sheets of the same document. Often the easiest way to do that is (when entering formulas) to click in the desired ranges and let the Formula Editor fill in the the sheet name automatically.

SG

Hi Pices,

Are you looking for a way to create a cell reference?

Here we go with Sheet 2 and Table 1.

On Sheet 1, we can use the & operator to concatenate Sheet, Table, Column, Row and create a formula that specifies a cell on Sheet 2. (You can substitute your real Sheet and Table names)

Formula in E2 ="Sheet "&A2&"::Table "&B2&"::"&C2&D2

Fill Down.

In Column F, the INDIRECT function is our friend.

= INDIRECT(E2)

Regards, and Happy Numbering!

Ian.