Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onEdit(e) {
- var ss = SpreadsheetApp.getActiveSpreadsheet()
- var s=ss.getActiveSheet()
- var nota=e.range.getA1Notation()
- if(nota=="C11"){
- var val=e.range.getValue()
- if(val=="No"){
- s.getRange("C12").setValue("0")
- s.getRange("C13").setValue("0")
- s.getRange("C14").setValue("0")
- }
- }}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement