Guest User

Untitled

a guest
Sep 19th, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. function onEdit(e){
  2. //Access the range with your parameter e.
  3. var range = e.range;
  4. var spreadSheet = SpreadsheetApp.openById("18AmVxMf8Q2oWvAsfh2KJ6hR-gC1FH6goul9Vocike1w");
  5. var column=e.range.getColumn();
  6. var row = e.range.getRow();
  7. var cell = e.range.getA1Notation();
  8. //do whatever you need with that range
  9. var allcolumns=[2,3];
  10. if(allcolumns.indexof(column)>-1){
  11. for (var i=column+1;i<column+2;i++){
  12. SpreadsheetApp.getactivesheet().getrange(row,i).setvalue(e.value);
  13. }
  14. SpreadsheetApp.getactivesheet().getrange(cell).setvalue('');
  15.  
  16. }
  17.  
  18. }
Add Comment
Please, Sign In to add comment