Prompt Title: get Current Workbook Name and sheet

To get the name of the current Google Sheets workbook, you can use the following formula:

=MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-1)

This formula will extract the name of the current workbook from the full file path of the Google Sheet.

Alternatively, you can use the following custom function:

javascriptCopy code
function getCurrentWorkbookName() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  return spreadsheet.getName();
}

To use this custom function:

1. Open your Google Sheet.
2. Go to the "Tools" menu and select "Script editor".
3. In the Script Editor, paste the above code.
4. Save the script (File > Save).
5. Go back to your Google Sheet.
6. In any cell, enter the following formula:

=getCurrentWorkbookName()

This will call the custom function and return the name of the current workbook.