Here my code @Wiz.Wazeer
function ResetOnChange(e)
{
var spreadsheet = SpreadsheetApp.getActive();
var Row= spreadsheet.getCurrentCell().getRow();
var Colum= spreadsheet.getCurrentCell().getColumn();
var CellButtom= spreadsheet.getRange('E'+Row).getValue();
// SpreadsheetApp.getActiveSpreadsheet().toast(e.changeType)
if (e.changeType === 'EDIT' && Colum ==5 && CellButtom == true)
{
spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Calculos'), true);
// Browser.msgBox("La celda que cambio fue... " + 'E'+Row + " ... valor: "+ CellButtom);
var RangeToDel= "C"+ Row + ":" + "D" + Row
spreadsheet.getRange('E'+Row).setValue(false);
// Browser.msgBox("Rango a Borrar: " + RangeToDel);
spreadsheet.getRange(RangeToDel).activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
}
}
As Jeef wrote above, you will need to authorize the trigger to your own google account to fire this script. At the 1st time, Google will ask your authorization for running this.
Saludos