title: How to run a function that only does something if a value is not empty in Google Apps Script?
body: <pre><code> var analyst = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet Details").getRange(7,3).getValue();
  </code></pre>
  
  <p>How do I write a function that only pushes the event if name of the analyst is not empty?</p>
  
  <pre><code>iSheet.getRange(lowerBound+1,2,dumpL,21).setValues(whole)
  </code></pre>