Skip to content

Instantly share code, notes, and snippets.

@GitHubKtShoe
GitHubKtShoe / update log
Last active January 20, 2022 18:36
This will produce a timestamp and a username email in Columns 1 and 2 of any sheet in google Sheets
function onEdit(e) {
var row = e.range.getRow()
var sh = e.source.getActiveSheet();
var col = e.range.getColumn()
var header = sh.getRange(1, col).getValue(); // I know this is var is not right...
if (row > 1 && col > 2){
e.source.getActiveSheet()
.getRange(row,1)
.setValue(new Date());}