enter image description hereI want to get a formula or script to get information about the author of the last cell modified in Google sheet
I want to expecting Danil Pobirsky but i can’t
I used Apps Sripts
<code>function getCreator(row) {
var range = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(row, 1, 1, SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getMaxColumns());
var cell = range.getCell(1, 1);
return cell.getValue();
}
</code>
<code>function getCreator(row) {
var range = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(row, 1, 1, SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getMaxColumns());
var cell = range.getCell(1, 1);
return cell.getValue();
}
</code>
function getCreator(row) {
var range = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(row, 1, 1, SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getMaxColumns());
var cell = range.getCell(1, 1);
return cell.getValue();
}