title: Google Scripts to Copy Image
body: <p>After the Google Scripts update, I tried to run one of mine and it gave me an error I can't figure out.</p>
  <p>I am trying to copy an image that is a formula ( Example: <code>=image(&quot;link here&quot;)</code> but ever since the update it copies CellImage and does not copy the formula. I have tried a few other pieces but all seem to lead to just &quot;CellImage&quot; text being copied instead of the actual formula or image.</p>
  <p>Does anyone have any ideas or know what change to implement?</p>
  <pre><code>function getItemName(CellName) {
   return SpreadsheetApp.openById('Google Sheet ID').getSheetByName('Sheet1').getRange(CellName).getValue();}
  
  function getItemImage(CellName) {
  return SpreadsheetApp.openById('Google Sheet ID').getSheetByName('Sheet1').getRange(CellName).getFormula();}
  
  var item = getItem('row + column');
  if (item == '') {
  item = getItemImage('row + column')
  }
  </code></pre>