Advertisement
Guest User

Untitled

a guest
Sep 20th, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. function onEdit(e) {
  2.  
  3. var editRange = { // B3:AL13
  4. top : 3,
  5. bottom : 12,
  6. left : 2,
  7. right : 38
  8. };
  9.  
  10. //Get sheet from which the event occured
  11. var range = e.range
  12. var sheet = range.getSheet();
  13. var name = sheet.getName();
  14.  
  15. //Exit if sheet is not a sheet where cells should be changed
  16. if (name != "Section 1 Homework") return;
  17.  
  18. // Exit if we're out of range
  19. var thisRow = e.range.getRow();
  20. if (thisRow < editRange.top || thisRow > editRange.bottom) return;
  21.  
  22. var thisCol = e.range.getColumn();
  23. if (thisCol < editRange.left || thisCol > editRange.right) return;
  24.  
  25. //Exit if the cell is not blank
  26. if (!range.isBlank()) return;
  27.  
  28. //Set the cell value to the default formula
  29. range.setValue( "=if(INDEX('Section 1 Attendance'!A1:AL12, " + thisRow + ", " + thisCol + ") = "A", "A", "")" )
  30. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement