Guest User

Untitled

a guest
Jul 18th, 2018
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. function TimeStamp(event)
  2. {
  3. var timezone = "GMT+5.5";
  4. var timestamp_format = "MM-dd-yyyy"; // Timestamp Format.
  5. var updateColName = "Folder ID for Link TS";
  6. var timeStampColName = "Actual date of Link Shared";
  7. var sheet = event.source.getSheetByName('Probe Sheet'); //Name of the sheet where you want to run this script.
  8.  
  9.  
  10. var actRng = event.source.getActiveRange();
  11. var editColumn = actRng.getColumn();
  12. var index = actRng.getRowIndex();
  13. var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues();
  14. var dateCol = headers[0].indexOf(timeStampColName);
  15. var updateCol = headers[0].indexOf(updateColName); updateCol = updateCol+1;
  16. if (dateCol > -1 && index > 1 && editColumn == updateCol) { // only timestamp if 'Last Updated' header exists, but not in the header row itself!
  17. var cell = sheet.getRange(index, dateCol + 1);
  18. var date = Utilities.formatDate(new Date(), timezone, timestamp_format);
  19. cell.setValue(date);
  20. }
  21. }
Add Comment
Please, Sign In to add comment