79442782

Date: 2025-02-16 08:14:52
Score: 1
Natty:
Report link

This works

function onEdit(e) {

var triggerCell = 'A14';

var incrementCell = 'a12';

var ss = SpreadsheetApp.getActiveSpreadsheet();

var editedCell = ss.getRange("a14")

if (editedCell.getA1Notation() === triggerCell) {

var currentValue = ss.getRange(incrementCell).getValue();

var newValue = currentValue + 1;

ss.getRange(incrementCell).setValue(newValue);

} }

Reasons:
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: uncleuhls