ws.getRange(“c2”).setFormula(‘=query(IMPORTRANGE(“1WtWWCnGLzhk5RkvRpwR7nKipqeDYqpVor9U7OMaVIy4/edit#gid=0″,”Sheet1!a1:e12″),” select sum(Col5) label sum(Col5)””,0)’);
https://docs.google.com/spreadsheets/d/1Kp3rk-7TIYHAEDZvkE3PpSRCjs1U3HRCKW45XitmoFo/edit#gid=0
Syntax error: SyntaxError: missing ) after argument list line: 11 file: Code.gs
the formula works fine in google sheet, but not in script, any help?
i want google script for query importrange with label clause without header(”) in select query
New contributor
user25125700 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.