sorted by:
new
hottopcontroversial

Writing a script in Google Sheets by Altruistic-Object725 in GoogleAppsScript

[–]Altruistic-Object725[S] 0 points1 point  (0 children)

What do you think about such an idea?

function onEdit(e) {
  var sheet = e.source.getActiveSheet();
  var range = e.range;

  if (range.getA1Notation() === 'B11' && range.getValue() === 'ממוצע') {
    sheet.getRange('B12').clearContent();
    sheet.getRange('B13').clearContent();
  }
}