title: Internal hyperlink to "Jump to 'Today'"
body: <p>I have a sheet that was in Excel, but is now in Google Sheets. It had a HYPERLINK formula that would jump to the row with today's date in Column B (handy for daily logging of information). The formula was:</p>
  
  <pre><code>=HYPERLINK("#A"&amp;MATCH("TODAY",A3:A629,0)+3&amp;":A"&amp;MATCH("TODAY",A3:A629,0)+3,"Jump to today")
  </code></pre>
  
  <p>It worked by looking for the cell in Column A containing <code>TODAY</code>, which is driven by an IF formula based on the date in column B. That HYPERLINK functionality doesn't work in Google Sheets.  </p>
  
  <p>Is there a way to fix it, or another way around it?</p>