I have a sheet that I have a button set up to run. However, buttons don't seem to run while using a mobile app. I've been looking at using the onEdit instead, but I can't even get this simplest function to work;
function onEdit(e) {
/**
SpreadsheetApp.getActiveSpreadsheet().getRange(e.range.getRow(), 3).setValue(new Date());
*/
SpreadsheetApp.getSheetByName('Sandbox').getRange(e.range.getRow(), 3).setValue(new Date());
}
I've tried both of the examples at separate times, but nothing. The intent is to simple recognize a cell was updated, and put the date/time in the 3 column (column C).
I only have 1 onEdit script, and I am the owner of the spreadsheet, with all rights. Any thoughts as to why I'm not able to get this to write the date/time in column C in the row that I've updated?