Advertisement
cpennell

Untitled

Apr 26th, 2019
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. function onEdit(e) {
  2. var ss = SpreadsheetApp.getActiveSpreadsheet()
  3. var s=ss.getActiveSheet()
  4. var nota=e.range.getA1Notation()
  5. if(nota=="C11"){
  6. var val=e.range.getValue()
  7. if(val=="No"){
  8. s.getRange("C12").setValue("0")
  9. s.getRange("C13").setValue("0")
  10. s.getRange("C14").setValue("0")
  11. }
  12. }}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement