title: "Loading" issue with some cells. My Google Spreadsheet is not updating and the google apps script doesn't work properly
body: <p>I have a questionnaire with Google Form on my site. Whenever an user fill out the questionnaire, its answers are used in a spreadsheet to evaluate something. The answers are stored properly by the spreadsheet. The SS does some calculations and in a different sheet, called &quot;Report&quot;, I store the result. My GS script sends an email to the user with its result. I've set an activator every 30 minutes to run the sendEmail function. This morning the script doesn't work because the result in the spreadsheet were not evaluated. Te return is &quot;#Name?&quot; for the result cell.</p>
  <p>How is it possible to keep updated the spreadsheet? At the beginning of the function I do:</p>
  <pre><code>var EMAIL_SENT = 'EMAIL_SENT';
  function sendEmail() {
    //TO DO: Active Sheet Check
    var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Report');
  </code></pre>
  <p>Is there some operation to update the ss: basically to run all the mathematical operation?
  Do I need to deploy the script?</p>