title: Using Filter on Google Spreadsheet
body: <p>I want to apply a filter to my Google spreadsheet.</p>
  
  <p>Column J of my <code>AllCurrent</code> sheet has some rows with value <code>2016</code> so why isn't this working?<br>
  I threw in my  <code>=IF(MONTH(TODAY()) &gt; 4,YEAR(TODAY())+1,YEAR(TODAY()))</code> part in a cell and it evaluated to 2016.</p>
  
  <p>Here's the filter: <code>=filter(AllCurrent!A2:Z,AllCurrent!J2:J = IF(MONTH(TODAY()) &gt; 4,YEAR(TODAY())+1,YEAR(TODAY())))</code></p>