Cfrgtkky

I wrote a function a while ago to determine if a sheet in a workbook already exists. Here is the function:

function SheetNameExists(name){

  return (ActiveSpreadSheet().getSheetByName(name).toString().indexOf(name) != 0);

}

All of a sudden within the last month or so I get a TypeError: Cannot call method "toString" of null. (line 105, file "Code"). Line 105 is the return statement.

Up until this error started happening I have had no issues with any of the scripts on this Sheet. I did not change anything in the code-behind.

Did Google change up something without providing deprecation support?

EDIT: I forgot ActiveSpreadsheet() was not a built-in function when I wrote all this out. This is the code I wrote to get it:

function ActiveSpreadSheet(){

  return SpreadsheetApp.getActiveSpreadsheet();

}

I question how this could have worked before. getSheetByName(name) will return a Sheet object. toString() simply returns the string "Sheet". So it will only match name if name is "Sheet". However your problem is quite simple.

var active = SpreadsheetApp.getActiveSpreadsheet();  // For sure the active spreadsheet

var sheet = active.getSheetByName(name);  // Where name is a string representing a sheet name

if( sheet ) return true;  // Sheet with name exists

return false;  // Other wise sheet is null or does not exist