How to get the current sheet name into the cell in Numbers.app

numbers

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 to Feb (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 as Feb, want get to some cell the string Feb.

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… 🙁

Best Answer

REGEX.EXTRACT(REFERENCE.NAME(;2);"[^:]+";;) returns the sheet name of the current sheet

Related Question