Is there a Google Sheets formula to put the name of the sheet into a cell?

Question

The following illustration should help:

Answer 1

Here is what I found for Google Sheets:

To get the current sheet name in Google sheets, the following simple script can help you without entering the name manually, please do as this:

1. Click Tools > Script editor

2. In the opened project window, copy and paste the below script code into the blank Code window, see screenshot:

......................

function sheetName() {   return SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getName(); } 

Then save the code window, and go back to the sheet that you want to get its name, then enter this formula: =sheetName() in a cell, and press Enter key, the sheet name will be displayed at once.

See this link with added screenshots: https://www.extendoffice.com/documents/excel/5222-google-sheets-get-list-of-sheets.html