Hi, I tried to use google script to replace query importrange formula in google sheet which contains label clause with null(”)
ws.getRange(“c2”).setFormula(‘=query(IMPORTRANGE(“1WtWWCnGLzhk5RkvRpwR7nKipqeDYqpVor9U7OMaVIy4/edit#gid=0″,”Sheet1!a1:e12″),” select sum(Col5) label sum(Col5)””,0)’);