Google SpreadSheets Auto Link Script

ticketLink

function ticketLink() {
  // configuration
  var sheetName = 'Sample1';
  var redmineUrl = 'http://redmine.example.com/issues/';
  var targetRange = 'A2:A';

  var doc = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = doc.getSheetByName(sheetName);
  var all = sheet.getRange(targetRange);
  var height = all.getHeight();
  
  for (var i = 1; i <= height; i++) {
    var cell =  all.getCell(i, 1);
    var v = cell.getValue();
    if (v.toString().match(/^#(\d+)/)) {
      var ticket = RegExp.$1;
      var formula = '=HYPERLINK("' + redmineUrl + ticket + '";"' + v + '")';
      cell.setFormula(formula);
    }
  }
}

Script Editor で突っ込んで trigger を適当に設定すれば自動的に実行される