title: Filter or delete row if cell is empty
body: <p>I'm looking to have a way to check cells on a specific column to see if it's empty. If it's in fact empty, filter or delete the row.</p>
  
  <p>I tried to use code from similar questions to no success, as there seem to be multiple ways of doing it.</p>
  
  <p>What I understand so far is I need to define the usual values:</p>
  
  <pre><code>var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Ordering"); // The particular sheet I'm using
  var rows = ss.getDataRange(); // I assume this counts the rows?
  var columntocheck = ss.getRange(1, 7, rows); // This defines the column I want to check for empty cells
  var values = rows.getValues(); // Define value of the row to be checked?
  </code></pre>
  
  <p>This is where I'm not sure how to approach the next step. I see most people use for loop to check each row for data length or for "" or "0".</p>
  
  <p>Would appreciate any tips.   </p>