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

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

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.

Originally Posted by PeteABC123

Please Login or Register  to view this content.

Pete

Have you checked that this works in Google Sheets?

Sorry I meant the file name

Originally Posted by PeteABC123

Please Login or Register  to view this content.

Pete

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

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


Cheerio.
Pete

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.

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

Please Login or Register  to view this content.

Then in the worksheet.
0.JPG