Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {var selectedCell = ss.getActiveRange();
- { if( selectedCell.getColumn() == 31) {
- var check1 = selectedCell.offset(TIMERECIEVE[0],TIMERECIEVE[1]);
- var check2 = selectedCell.offset(DATETRECIEVE[0],DATETRECIEVE[1]);
- if(selectedCell.getValue() > 0)
- {check1.setValue(new Date())
- check2.setValue(new Date());}}}
- { if( selectedCell.getColumn() == 32){
- var check = selectedCell.offset(DATEDONE[0],DATEDONE[1]);
- if( selectedCell.getValue() >0)
- check.setValue(new Date());}}
- { if( selectedCell.getColumn() == 10){
- var check3=selectedCell.offset(DATECHECK[0],DATECHECK[1]);
- if( selectedCell.getValue() === 'App')
- check3.setValue(new Date());}}
- { if( selectedCell.getColumn() == 11){
- var check4=selectedCell.offset(DATECHECK[0],DATECHECK[1])
- if( selectedCell.getValue() === 'Done')
- check4.setValue(new Date());}}
- }}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement