I'm trying to pull the name of another table on the same sheet into a cell.
Table 1 lists the totals of several other tables: Table 2, Table 3, Table 4, etc.. I could just type the subordinate table names in columns A, but I find it more interesting to use a function call to display the name. That way if I change the a subordinate table name, the summary table reflects that.
NAME.REFERENCE only seems to reference the same table. Any solution?
iCloud says the link is no longer good, the user stopped sharing. The screenshot does not show any formulas. Is it the error triangle? What do you want there and what is the formula you have there now?
REFERENCE.NAME(Table 1::B1,1) will give you the string "Table 1::B1", if that is the like what you were looking for. With FIND and LEFT you can extract just the table name.
=LEFT(REFERENCE.NAME(Table 1::B1,1),FIND("::",REFERENCE.NAME(Table 1::B1,1))−1)
iCloud says the link is no longer good, the user stopped sharing. The screenshot does not show any formulas. Is it the error triangle? What do you want there and what is the formula you have there now?
REFERENCE.NAME(Table 1::B1,1) will give you the string "Table 1::B1", if that is the like what you were looking for. With FIND and LEFT you can extract just the table name.
=LEFT(REFERENCE.NAME(Table 1::B1,1),FIND("::",REFERENCE.NAME(Table 1::B1,1))−1)
I am confused.
Your first post said "I'm trying to pull the name of another table on the same sheet into a cell". If you use REFERENCE.NAME to reference a cell in another table and you have the second parameter set to "table" (or 1), it returns the table name and the cell address. You can strip off the cell address and have just the table name remaining, as shown in my prior post. Is this not the answer to that question?
In your most recent post it now sounds like you want to change the table name using REFERENCE.NAME. That cannot be done, the titles have to be typed in.
No... these factions all reference table cells. I'm trying to reference the table Title. I'm thinking this can't be done.
Interestingly, in the Numbers app, you can double click the header cell to edit. Accessing Numbers in iCloud.com from a browser , the field appears in the Inspector.
Read the rest of the description of the function. One parameter specifies how much information the function will provide, including the table name.
I did, but the first parameter references the same table.
Here is an example sheet.
https://www.icloud.com/numbers/06bWvDa768o7rDNWRGmbZq_Kw#Example
Or, maybe better (assuming it works)
=REGEX.EXTRACT(REFERENCE.NAME(Table 1::B1,1),"^([^:])+")
I don't understand the syntax for regular expressions. I got that bunch of characters from the Internet where someone wanted all text to the left of a comma. I substituted a colon for the comma. It seems to work.
REFERENCE.NAME Table Name
