title: Google Apps Script in Google Sheet - Convert formulas to static values - cell function to value
body: <p>Is there a Google Apps Script method that will change a cell with a formula to one with a static value?</p>
  <p>The reason for this is to avoid lag in the Sheet from lots of cell formulas recalculating as the sheet becomes larger.</p>
  <p>I want to make the sheet replace old formulas with static values since they won't be changing.</p>