Google Sheets script: function refreshFormula(aToResfresh); For each cell in the array, force refresh the containing formula.

RefreshFormula.gs

/**
 * Google Sheets script: function refreshFormula(aToResfresh)
 * For each cell in the array, force refresh the containing formula.
 *
 * @param {Array} aToResfresh The array of cells with formula to force refresh.
 * @return {Void}
 */
function refreshFormula(aToResfresh = []) {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(),
      sheet = spreadsheet.getActiveSheet(),
      a = [];

  aToResfresh.forEach(function(e) {
    var cell = sheet.getRange(e);
    a[e] = cell.getFormula();

    if (a[e]) {
      spreadsheet.toast('Refresh formula ' + e);
      cell.setFormula(a[e].replace('=', '?'));
    }
  });

  SpreadsheetApp.flush();

  aToResfresh.forEach(function(e) {
    var cell = sheet.getRange(e);

    if (a[e]) {
      cell.setFormula(a[e]);
    }
  });
}