SyntaxError: missing ) after argument list (line 3, file "Code.gs")

Question

I am trying to create a Google Sheet Script that sets a formula and autofills the formula for each new row added and getting the error: SyntaxError: missing ) after argument list (line 3, file "Code.gs")

Here is the script:

function myFunction() {
 var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
 ss.getRange("AE2").setFormula("=LEFT(F2,FIND("for $",F2)-1)");
 }

I can't figure out where the missing ) is? The formula works without any problems in the sheet itself

Honestly I am not experienced in writing scripts so any help will be appreciated

Color highlighting shows the issue. You have the nested quotes It sees "=LEFT(F2,FIND(" and than it errors out — epascarello
– epascarello, Commented May 1, 2020 at 17:51
If you need to have literal double quotes, it's better to use single quoted strings: ss.getRange("AE2").setFormula('=LEFT(F2,FIND("for $",F2)-1)'); — Álvaro González
– Álvaro González, Commented May 1, 2020 at 17:59

Rainer Plumer · Accepted Answer · 2020-05-01 17:51:43Z

1

You can try escaping your " marks.

function myFunction() {
   var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
   ss.getRange("AE2").setFormula("=LEFT(F2,FIND(\"for $\",F2)-1)");
}

answered May 1, 2020 at 17:51

Rainer Plumer

3,7533 gold badges28 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ganhammar · Accepted Answer · 2020-05-01 17:54:31Z

0

You'll need to escape the inner quotation marks otherwise they break the string input for setFormula to early and cause the SyntaxError. You escape characters in the string with a backslash (\).

function myFunction() {
 var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
 ss.getRange("AE2").setFormula("=LEFT(F2,FIND(\"for $\",F2)-1)");
 }

answered May 1, 2020 at 17:54

Ganhammar

1,9611 gold badge17 silver badges34 bronze badges

Collectives™ on Stack Overflow

SyntaxError: missing ) after argument list (line 3, file "Code.gs")

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related