I'm currently using the below script to auto date when a change is made to column 5 in a sheet named "SIP".
function onEdit(e) {
if ([5].indexOf(e.range.columnStart) != -1) {
e.range.offset(0, 1).setValue(new Date()).setNumberFormat("dd.MM.yyyy at HH:mm");
}
}
I need to use the same function but apply this to column 7 on a sheet named "Line" in the same work book.
What do I need to do so I can set up sheet specific scripts?
Bookmarks