参考サイト

/** @OnlyCurrentDoc */ function myFunction() { var spreadsheet = SpreadsheetApp.getActive(); spreadsheet.getRange('E2').activate(); spreadsheet.getCurrentCell().setValue('sss'); spreadsheet.getRange('F2').activate(); spreadsheet.getCurrentCell().setValue('ssss'); spreadsheet.getRange('G2').activate(); spreadsheet.getCurrentCell().setValue('sss'); spreadsheet.getRange('H2').activate(); spreadsheet.getCurrentCell().setValue('sss'); }; var ss = SpreadsheetApp.getActiveSpreadsheet(); var sh = ss.getActiveSheet(); function onEdit(e) { var row = e.range.getRow(); var col = e.range.getColumn(); var val = e.oldValue; if (sh.getSheetName() == "作業ログ" && (col == 2)) { sh.getRange(row,4).setValue('=GOOGLETRANSLATE(B'+row+',"auto","en")')//val); } }