title: Hide rows in google spreadsheet if Column A is empty?
body: <p>I'm trying to hide rows if Column A is empty. I want to apply this to specific sheets (Week1, Week2, Week3, Week4 and Week5). This is the code I have so far for Week1.</p>
  
  <pre><code> function ConditionalHideRow() {
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var sheet = ss.getSheetByName("Week1");
    var condition = sheet.getRange("A:A").getValue();
    if (condition = "EMPTY") {
      sheet.hideRows(1,125)
     }    
  </code></pre>
  
  <p>EDIT: Bonus question, is there a way I can get it to unhide when Column A is filled? I'm using a =query formula to populate my spreadsheet and the length will need to change as more data is added.</p>