Guest User

Untitled

a guest
Mar 21st, 2018
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. function isClosedColumnChanged(e)
  2. {
  3. var ss = SpreadsheetApp.getActiveSpreadsheet();
  4. var sheet = ss.getActiveSheet();
  5. //Get Active cell
  6. var mycell = ss.getActiveSelection();
  7. var cellrow = mycell.getRow();
  8. var isClosed = 'K' + (cellrow);
  9.  
  10. if (cellcol == 11)
  11. {
  12.  
  13. if (sheet.getRange(isClosed).getValue() == "closed")
  14. {
  15. messageit('its forbidden to close already-closed call');
  16. }
  17. }
  18. }
Add Comment
Please, Sign In to add comment