Is it possible to get the file name (text) to appear as text in my google sheet?

[rayted]

Hi guys,

I am naming the same copy of various sheets with different names.

I need to change text in a cell to use the name of the sheet. Is there a function to get the file name appear in a cell?

Thanks

[PeteABC123]

Please Login or Register  to view this content.

Pete

[AliGW]

Your thread title contradicts your question: do you want the file name or the sheet name?

For the sheet name, a very quick Google tells me that you will need to write a Google Sheets script for this.

[AliGW]

Please Login or Register  to view this content.

Pete

Have you checked that this works in Google Sheets?

[rayted]

Sorry I meant the file name

[rayted]

Please Login or Register  to view this content.

Pete

i`m sorry Pete, I meant the file name. I am using google sheets

[PeteABC123]

MyBad. I just was a bit eager in a moment of frantic frenetic frenzy.


Cheerio.
Pete

[AliGW]

To be fair, Ray did post in the appropriate sub-forum AND mention Google Sheets in his thread title!

As I said earlier, it doesn't look like there is a direct equivalent.

[CK76]

Add following in Google Script.
Tools->Script editor.

Please Login or Register  to view this content.

Then in the worksheet.
0.JPG