Clear Cells

[gvalero]

Hi again,

Here is the script you must have in your GS. Then you have to set it up a trigger based On Change event:

New Row in Spreadsheet for Every User

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.msgBo…

Saludos