Custom function get sheet name by gid

[oshliaer]

/**
 * Returns sheet's name by gid
 *
 * @param {number} gid The gid of the sheet.
 * @return {string} The name of the sheet.
 * @customfunction
 */

function getSheetNameByGid(gid){
  gid = +gid || 0;
  var res_ = undefined;
  var sheets_ = SpreadsheetApp.getActive().getSheets();
  for(var i = sheets_.length; i--; ){
    if(sheets_[i].getSheetId() === gid){
      res_ = sheets_[i];
      break;
    }
  }
  return res_.getName();
}

[oshliaer]

/**
 * Returns sheet's name by gid
 *
 * @param {GoogleAppsScript.Spreadsheet.Spreadsheet} spreadsheet
 * @param {number} gid The gid of the sheet.
 * @return {string} The name of the sheet.
 * @customfunction
 */

function getSheetNameByGid(spreadsheet, gid){
  gid = +gid || 0;
  var res_ = undefined;
  var sheets_ =spreadsheet.getSheets();
  for(var i = sheets_.length; i--; ){
    if(sheets_[i].getSheetId() === gid){
      res_ = sheets_[i];
      break;
    }
  }
  return res_.getName();
}