Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function TimeStamp(event)
- {
- var timezone = "GMT+5.5";
- var timestamp_format = "MM-dd-yyyy"; // Timestamp Format.
- var updateColName = "Folder ID for Link TS";
- var timeStampColName = "Actual date of Link Shared";
- var sheet = event.source.getSheetByName('Probe Sheet'); //Name of the sheet where you want to run this script.
- var actRng = event.source.getActiveRange();
- var editColumn = actRng.getColumn();
- var index = actRng.getRowIndex();
- var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues();
- var dateCol = headers[0].indexOf(timeStampColName);
- var updateCol = headers[0].indexOf(updateColName); updateCol = updateCol+1;
- if (dateCol > -1 && index > 1 && editColumn == updateCol) { // only timestamp if 'Last Updated' header exists, but not in the header row itself!
- var cell = sheet.getRange(index, dateCol + 1);
- var date = Utilities.formatDate(new Date(), timezone, timestamp_format);
- cell.setValue(date);
- }
- }
Add Comment
Please, Sign In to add comment