title: Triggering script by specific cell value
body: <p>I am pretty new to google sheets script development and am wondering how to trigger a clearAll script with cell value i.e. A1=100.
  My clearAll script works (see below), though I don't know what to add to it to trigger it using a specific cell value.</p>
  
  <pre><code>function clearAll() {
   var ss = SpreadsheetApp.getActiveSpreadsheet();
   var formresponses1 = ss.getSheetByName("formresponses1");
  formresponses1.clearContents();}
  </code></pre>
  
  <p>Thanks</p>