How to get the current sheet name into the cell in Numbers.app
Scenario:
- Have a spreadsheet (Numbers.app v3.6.2/El Capitan)
- it contains multiple
Sheets
(every sheet contains multiple tables, but this doesn't matter) - Every sheet is renamed to some defined name, for example the
Sheet 2
is renamed toFeb
(month name abbrev). - need get into the cell content the current sheet name e.g. something like the hypothetical function
=GETSHEETNAME()
, so in the sheet named asFeb
, want get to some cell the stringFeb
.
My reading of the Numbers.app
function reference failed and I doesn't find any function for such operation. Is it possible somehow?
EDIT
At the https://iworkautomation.com/numbers/sheet.html I found some applescript, but haven't idea how to use it... :(
Solution 1:
REGEX.EXTRACT(REFERENCE.NAME(;2);"[^:]+";;)
returns the sheet name of the current sheet