jeudi 30 avril 2020

Calling function when checking checkbox - Google Sheets

I am trying to call a function when someone check a checkbox. I came up with this so far but it is not working. Checkboxes are in cells F2 and F3

function onEdit(e) {
  var range = e.range
  if(range.getCell() == "F2") {
    resetData()
  }
  else if(range.getCell() == "F3") {
    renameSheet()
  }
}



Aucun commentaire:

Enregistrer un commentaire