Is there a formula so a cell can be titled the same as the sheet tab?

[srob93]

Hello,

I am wondering if there is a formula for gsheet so I can have a specific cell named the same as the sheet tab at the bottom?

See attached.

I need cell C1 to be titled 001 as per the tab at the bottom...

Any help would be great thank you! ?

 

[afonsomira]

Hello try this.

1. Go to Tools > Script gallery....
2. Search for "sheet name"
3. Install the script
4. Use it with =getCurrentSheetName().

Or this formula but I only tested it on excel 365 desktop
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

 

[srob93]

Hello try this.

1. Go to Tools > Script gallery....
2. Search for "sheet name"
3. Install the script
4. Use it with =getCurrentSheetName().

Or this formula but I only tested it on excel 365 desktop
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

Hello thank you for your reply.

Sorry I am such a novice with excel, and currently using gsheet.

Please can you further breakdown how this is done? Stuck even finding Script Gallery (I have a Script Editor??)

Thank you in advance

 

[afonsomira]

Sorry,
Try this one:

• Go to tools > Script Editor
• Write this function:

function sheetName() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];
  return sheet.getName();
}

• Save the script
• Return to your sheet
• Then enter =sheetName() into any cell

 

[srob93]

Sorry,
Try this one:

• Go to tools > Script Editor
• Write this function:

function sheetName() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];
  return sheet.getName();
}

• Save the script
• Return to your sheet
• Then enter =sheetName() into any cell

Thank you - getting closer!!

See attached.

Function copied in to the Script Editor but then get an error message saying "1:13:23 PM Error Attempted to execute sheetname, but it was deleted."

Any ideas??

 

[srob93]

Thank you - getting closer!!

See attached.

Function copied in to the Script Editor but then get an error message saying "1:13:23 PM Error Attempted to execute sheetname, but it was deleted."

Any ideas??

Hi again,

After leaving it for a few minutes it seems to have worked... almost!

See attached.

I have entered =sheetname() in to the cell but it links to the wrong sheet name! I need it to say '001' then '002' then '003' and so on... not '2021 Overview'

Many thanks - this is great so far!

 

[afonsomira]

Once again I apologize.
I tested it here only with a tab.
Please test this:

• Go to tools > Script Editor
• Write this function:

function mySheetName() {
  var key = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getName();
  return key;
}

• Save the script
• Return to your sheet
• Then enter =mySheetName() into any cell

 

[srob93]

Once again I apologize.
I tested it here only with a tab.
Please test this:

• Go to tools > Script Editor
• Write this function:

function mySheetName() {
  var key = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getName();
  return key;
}

• Save the script
• Return to your sheet
• Then enter =mySheetName() into any cell

PERFECT ? ? ? ? Afonsomira - thank you very much !

 

[afonsomira]

You're welcome.