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());}