Google Sheets filename in cell via formula instead of a script?

Question

Is there a FORMULA that will display the name of the file in a cell?

I've found scripts that will do it, formulas that will display the sheet name, but no luck finding a formula that will show the filename.

If I have to resort to the script, so be it. But I'd like to use formula if possible.

If this has been asked before, please point me to the post and I will delete this one.

Does this answer your question? [Is there a native function in Google Sheets that I can use to get the Spreadsheet name?](https://stackoverflow.com/questions/76111654/is-there-a-native-function-in-google-sheets-that-i-can-use-to-get-the-spreadshee) — horanimal, May 03 '23 at 16:30

score 1 · Accepted Answer · answered Apr 26 '23 at 13:23

1

No—unfortunately this is not possible with any built-in function.

The only way to do this with a function would be to use AppScript to write a custom one, which is essentially back to writing a script.

answered Apr 26 '23 at 13:23

horanimal

1

@TC76 Mind accepting this answer so we can remove this as the most-viewed “unanswered” question in the [google-sheets-formula] tag? Sadly almost 4 years later the answer to your question is still “no” :( – horanimal Apr 28 '23 at 21:45

score 0 · Answer 2 · answered Aug 23 '23 at 16:07

0

But adding this App Script will return the correct value (but slowly):

function GetGoogleSheetName() {
return SpreadsheetApp.getActiveSpreadsheet().getName();
}

answered Aug 23 '23 at 16:07

Mike Gifford

2 Answers2