# Reset values daily

**URL:** <https://community.glideapps.com/t/reset-values-daily/1457>\
**Category:** Ask for Help\
**Created:** [October 28, 2019, 10:53pm UTC](https://community.glideapps.com/t/reset-values-daily/1457 "2019-10-28T22:53:20Z")\
**Posts on this page:** 1\
**Showing post:** 17

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [April 7, 2020, 3:32am UTC](https://community.glideapps.com/t/reset-values-daily/1457/17 "2020-04-07T03:32:53Z")

</div>

The only recommendation would be to look at a bunch of script writing tutorials and write one. Then 2, then 3, etc… Then keep writing them until you are confident that it does what you want. To simply clear a few columns is pretty straight forward. If you wanted to clear the contents of columns E and F on Sheet2, this is the script.

```auto
function clearAFewColumns() {
  var sheet = SpreadsheetApp.getActive().getSheetByName('Sheet2');
  var lastRow = sheet.getLastRow();
  
  // Column E = 5; F = 6   
  sheet.getRange(2, 5, lastRow, 1).clearContent();
  sheet.getRange(2, 6, lastRow, 1).clearContent();
  
}

```

Do some Google searches on how to add a Box on a sheet, or create a menu item, and have it execute a function.

---

_[View the full topic](https://community.glideapps.com/t/reset-values-daily/1457)._