Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  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. }}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement