Wednesday, March 19, 2025

getModifiedSheetNames



function getModifiedSheetNames() {
  var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
  var sheetNames = sheets.map(sheet => sheet.getName());

  var removeText = "_SIT";  // Change this to the text you want to remove
  var addText = "https://telus-iot-5g.atlassian.net/browse/";     // Change this to the text you want to add

  // Modify sheet names: Remove specific text and add new text
  var modifiedSheetNames = sheetNames.map(name =>
    addText+ name.replace(removeText, '').replace(/\s+/g, '')
  );

  return modifiedSheetNames;
}

No comments:

Post a Comment