How to make google sheet file name appear in cell

[Bob Richardson]

I need the filename of my google sheet to appear in a cell because the phone app doesn't show the filename which is causing confusion for our users.  I know I can use scripts but the problem is the people using the spreadsheet "make a copy" of the sheet for their own use but then the script won't work without them giving it permission to run (which is a hassle because they are not tech savvy and there are a lot of them).

I need a formula to show the filename instead of a script.

Thank you for your help!

[Alexander Ivanov]

Hi!

OK. You have to add the javascript comment

/**
 *  @customfunction
 */
function ACTIVEBOOK(command) {
  return SpreadsheetApp.getActive()[command]();
}

The sample https://docs.google.com/spreadsheets/d/1hl1zEArivMDAeTycfUOjNYXT5oTA5cPmlgC6KLt-6D4/edit?usp=sharing Thry to make a copy