title: delete entire row if any cell is empty
body: <p>Just like the title says. I found a solution if one column is blank, but not if any are blank. </p>
  
  <p>I crafted this with the help of another post, though I don't have a clue re: google scripts.</p>
  
  <pre><code>function onEdit(e) {
  
  
   //Logger.log(JSON.stringify(e)); 
    //{"source":{},"range":{"rowStart":1,"rowEnd":1,"columnEnd":1,"columnStart":1},"value":"1","user":{"email":"","nickname":""},"authMode":{}}
    try {
      var ss = e.source; // Just pull the spreadsheet object from the one already being passed to onEdit
      var s = ss.getActiveSheet();
  
      // Conditions are by sheet and a single cell in a certain column
      if (s.getName() == 'Sheet1' &amp;&amp;  // change to your own 
          e.range.columnStart == 1 &amp;&amp; e.range.columnEnd == 99 &amp;&amp;  // only look at edits happening in col C which is 3
          e.range.rowStart == e.range.rowEnd ) {  // only look at single row edits which will equal a single cell
        checkCellValue(e); 
      }
    } catch (error) { Logger.log(error); }
  };
  
  function checkCellValue(e) {
    if ( !e.value || e.value == 0) {  // Delete if value is zero or empty
      e.source.getActiveSheet().deleteRow(e.range.rowStart);
    }
  }
  </code></pre>
  
  <p>problem is, I have no idea how to actually "use" it</p>