title: Triggered functions and IMPORTRANGE
body: <p>I have a Google Apps Script that compares information submitted in a Google form to information that is brought into the Google spreadsheet using the IMPORTRANGE function.  The script works perfectly if I run it manually but if it runs from the form submit trigger it reports that it isn't getting the correct information from the cells using IMPORTRANGE.</p>
  
  <p>Is there a way around this, like is there a quick function I can add that forces import range to update?</p>
  
  <p>I have already tried to add a wait time of up to 10 minutes and it hasn't changed the results.</p>