Advertisement
Guest User

Untitled

a guest
Oct 23rd, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. function onEdit(evt) {
  2. var sheet = evt.source.getActiveSheet();
  3. var column = sheet.getActiveRange().getColumn();
  4. var row = sheet.getActiveRange().getRow();
  5. var timestamp = "HH:mm:ss dd.MM.yy";
  6. var timezone = "Europe/Riga";
  7. if ( sheet.getName() == "Booking" && column == 14 ) {
  8. sheet.getRange(row, 15).setValue(Utilities.formatDate(new Date(), timezone , timestamp));
  9. }
  10. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement