Advertisement
RemcoE33

timestamp u/-LuciditySam-

Jul 7th, 2021
137
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function onEdit(e) {
  2.   var s = e.source.getActiveSheet();
  3.   var row = e.getRow();
  4.   var col = e.getColumn();
  5.   var offsetCol = (col == 2) ? 11 : 12
  6.   var offsetValues = e.source.getActiveSheet().getRange(row, offsetCol, 1, 2).getValues().flat()
  7.   var curDate = Utilities.formatDate(new Date(), "GMT-5", "dd MMM yyyy")
  8.   var curTime = Utilities.formatDate(new Date(), "GMT-5", "HHmm")
  9.  
  10.   if (s.getName() == "Input" && row >= 2 && col == 2 && e.value == "TRUE" && offsetValues.inculdes('')) {
  11.     s.getRange(row, 13, 1, 2).setValues([curDate, curTime]);
  12.   } else if (s.getName() == "Input" && row >= 2 && col == 3 && e.value == "TRUE" && offsetValues.inculdes('')) {
  13.     s.getRange(row, 15, 1, 2).setValues([curDate, curTime]);
  14.   }
  15. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement