I'm creating a google sheet app script that will log the timestamp to another row (Column 40) upon editing of other cell value (column 3). This is what I have so far

Documentation: https://developers.google.com/apps-script/reference/base/ui#alert(String)

Hope it helps.

CodePudding user response：

use offset instead of getRange

e.range.offset(0,38-col).setValue(currentDate)