title: Writing a script to remove formulae in Google sheets
body: <p>I have a sheet of data that reads in information from another sheet throughout the day via a vlookup. The other sheet is linked to a website via an importxml which refreshed throughout the day. </p>
  
  <p>Once the information has been obtained, i need to remove the formula and leave the values in place. I.e. Once the cell no longer reads as #N/A, replace that row of data with values. My idea is then to set this as a trigger to then run every hour, looping through each row and updating all the rows that no longer show #N/A.</p>