# Clear Cells

**URL:** <https://community.glideapps.com/t/clear-cells/7058>\
**Category:** Ask for Help\
**Created:** [April 14, 2020, 7:53pm UTC](https://community.glideapps.com/t/clear-cells/7058 "2020-04-14T19:53:00Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [September 26, 2020, 2:03pm UTC](https://community.glideapps.com/t/clear-cells/7058/9 "2020-09-26T14:03:49Z")

</div>

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](https://community.glideapps.com/t/new-row-in-spreadsheet-for-every-user/6475/56):
>
> 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

---

_[View the full topic](https://community.glideapps.com/t/clear-cells/7058)._