SHARE
TWEET

Untitled

a guest Jun 16th, 2019 57 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. {var selectedCell = ss.getActiveRange();
  2.  {   if( selectedCell.getColumn() == 31) {
  3.    var check1 = selectedCell.offset(TIMERECIEVE[0],TIMERECIEVE[1]);
  4.    var check2 = selectedCell.offset(DATETRECIEVE[0],DATETRECIEVE[1]);
  5.   if(selectedCell.getValue() > 0)
  6.     {check1.setValue(new Date())
  7.   check2.setValue(new Date());}}}
  8.  
  9. {   if( selectedCell.getColumn() == 32){
  10.     var check = selectedCell.offset(DATEDONE[0],DATEDONE[1]);
  11.     if( selectedCell.getValue() >0)
  12.       check.setValue(new Date());}}
  13.  
  14.  {  if( selectedCell.getColumn() == 10){
  15.   var check3=selectedCell.offset(DATECHECK[0],DATECHECK[1]);
  16.   if( selectedCell.getValue() === 'App')
  17.     check3.setValue(new Date());}}
  18.  
  19.  {  if( selectedCell.getColumn() == 11){
  20.   var check4=selectedCell.offset(DATECHECK[0],DATECHECK[1])
  21.   if( selectedCell.getValue() === 'Done')
  22.     check4.setValue(new Date());}}
  23.  
  24.  
  25.  
  26.   }}
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top