title: google sheets function gives weird #NAME? error
body: <p><a href="https://i.stack.imgur.com/E7VTM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/E7VTM.png" alt="Screenshot of error"></a>
  I get this error from my query(import... ) function all the time on just one google sheet.  The work around is to delete the letter o from the formula, wait 10 seconds and then put the o back in.  Is there a way to solve this without having to remove the letter o.  This is the equivalent of turning it off and on again.</p>
  
  <p>Here are a list of suggestions that didn't work.
  1. Removing the custom getLink() function and wrapping it in an iferror function.</p>