# Clear Cells **URL:** \ **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:** 9\ **Page:** 1
**Author:** ![SPETZ](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spetz/32/5618_2.png) [@SPETZ](https://community.glideapps.com/u/SPETZ)\ **Post date:** [April 14, 2020, 7:53pm UTC](https://community.glideapps.com/t/clear-cells/7058/1 "2020-04-14T19:53:00Z")
Hi, Is anybody able to trigger a procedure on glide to clear some cells within one raw on different columns in the sheet? ---
**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:** [April 14, 2020, 8:59pm UTC](https://community.glideapps.com/t/clear-cells/7058/2 "2020-04-14T20:59:07Z")
anything like this? [https://multicalc.glideapp.io](https://multicalc.glideapp.io) ---
**Author:** ![SPETZ](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spetz/32/5618_2.png) [@SPETZ](https://community.glideapps.com/u/SPETZ)\ **Post date:** [April 15, 2020, 11:30am UTC](https://community.glideapps.com/t/clear-cells/7058/3 "2020-04-15T11:30:42Z")
**Yes Exactly!** it work for me one time and stop. i tried to copy it but didn’t able to reverse engineer your procedure. can you assist me pls? thanx in advance! ---
**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:** [April 15, 2020, 12:37pm UTC](https://community.glideapps.com/t/clear-cells/7058/4 "2020-04-15T12:37:04Z")
@SPETZ Take a look at this post and follow some steps we shared there: > [@New Row in Spreadsheet for Every User](https://community.glideapps.com/t/new-row-in-spreadsheet-for-every-user/6475/48): > > Hi again friends, Here I modified my demo APP and included a Reset switch to clear the input values at the same time via script You will see some lag to clear values but it is caused by Google Sheet’s script and/or your internet speed. I hope it can be useful to anyone. Saludos Gavp I hope it helps. Saludos Gavp ---
**Author:** ![Herbert\_Coleman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/herbert_coleman/32/4451_2.png) [@Herbert\_Coleman](https://community.glideapps.com/u/Herbert_Coleman)\ **Post date:** [September 25, 2020, 6:50am UTC](https://community.glideapps.com/t/clear-cells/7058/5 "2020-09-25T06:50:47Z")
Hi, Gavp, I like the app. It worked when I logged into your app. However, when I made a copy of it, the reset button no longer works. I there something else I’m supposed to do? I noticed there’s an “Agreed” checkbox on the login page. Should I check that? ---
**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, 1:03am UTC](https://community.glideapps.com/t/clear-cells/7058/6 "2020-09-26T01:03:43Z")
Hola @Herbert_Coleman I think the problem is the script. When you copied my template you could see my script and its trigger? ---
**Author:** ![Herbert\_Coleman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/herbert_coleman/32/4451_2.png) [@Herbert\_Coleman](https://community.glideapps.com/u/Herbert_Coleman)\ **Post date:** [September 26, 2020, 5:02am UTC](https://community.glideapps.com/t/clear-cells/7058/7 "2020-09-26T05:02:45Z")
No, I didn’t see the script or the triggers. where can i find them? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 26, 2020, 10:14am UTC](https://community.glideapps.com/t/clear-cells/7058/8 "2020-09-26T10:14:51Z")
I think when a sheet is duplicated, only the content is transferred over, not the scripts and triggers. I have to reconfigure them a bunch of times for my clients. ---
**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")
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