Return to Answer

spelling fix

Source Link

1.6k
2
11
46

OR... you could do a simple script, first giving the value cerozero (0) then including the formula back and this do the trick:

  var cell = sheet.getRange("B1:B1"); //SHEET TO INSERT VALUE
  cell.setFormula("=0");
   Utilities.sleep(2000); //JUST TO GIVE TIME TO UPDATE (OPTIONAL)
  var cell = sheet.getRange("B1:B1");
  cell.setFormula("=ImportRange(\"YOUR_SHEET_ID\",\"RANGE_TO_INSERT\")");

OR... you could do a simple script, first giving the value cero (0) then including the formula back and this do the trick:

  var cell = sheet.getRange("B1:B1"); //SHEET TO INSERT VALUE
  cell.setFormula("=0");
   Utilities.sleep(2000); //JUST TO GIVE TIME TO UPDATE (OPTIONAL)
  var cell = sheet.getRange("B1:B1");
  cell.setFormula("=ImportRange(\"YOUR_SHEET_ID\",\"RANGE_TO_INSERT\")");

OR... you could do a simple script, first giving the value zero (0) then including the formula back and this do the trick:

var cell = sheet.getRange("B1:B1"); //SHEET TO INSERT VALUE
cell.setFormula("=0");
Utilities.sleep(2000); //JUST TO GIVE TIME TO UPDATE (OPTIONAL)
var cell = sheet.getRange("B1:B1");
cell.setFormula("=ImportRange(\"YOUR_SHEET_ID\",\"RANGE_TO_INSERT\")");

Source Link

created Aug 18, 2017 at 16:45

Samuel Félix

OR... you could do a simple script, first giving the value cero (0) then including the formula back and this do the trick:

  var cell = sheet.getRange("B1:B1"); //SHEET TO INSERT VALUE
  cell.setFormula("=0");
   Utilities.sleep(2000); //JUST TO GIVE TIME TO UPDATE (OPTIONAL)
  var cell = sheet.getRange("B1:B1");
  cell.setFormula("=ImportRange(\"YOUR_SHEET_ID\",\"RANGE_TO_INSERT\")");