google-apps-script - 仅当单元格显示“是”时才获取填充单元格的日期

Question

我需要更改以获取仅使用单词“YES”更新 B 列的日期。

function onEdit() {
  var s = SpreadsheetApp.getActiveSheet();
  if (s.getName() == "EXPORTACION") { //checks that we're on Sheet1 or not
    var r = s.getActiveCell();
    if (r.getColumn() == 2) { //checks that the cell being edited is in column B
      var nextCell = r.offset(0, 1);
      if (nextCell.getValue() === 'YES') //checks if the adjacent cell is empty or not?
        nextCell.setValue(new Date());
    }
  }
}

标签： google-apps-scriptgoogle-sheets

Answer 1

function onEdit(e) {
  var sh=e.range.getSheet();
  if(sh.getName()=="EXPORTACION" && e.range.columnStart==2 && e.value=="YES") { 
    e.range.offset(0,1).setValue(new Date());
  }
}