Can't make the formula work from apps scritp to google sheet

[Proiz]

function FormSmartInfrastructures() {

  var spreadsheet = SpreadsheetApp.getActive();

  var sheet = spreadsheet.getSheetByName("Foglio1");

  var rigaCorrente = sheet.getLastRow();

  spreadsheet.getRange('A1').activate();

  spreadsheet.getCurrentCell().getNextDataCell(SpreadsheetApp.Direction.DOWN).activate();

  spreadsheet.getCurrentCell().getNextDataCell(SpreadsheetApp.Direction.NEXT).activate();

  spreadsheet.getCurrentCell().offset(0,1).activate();

  var key = sheet.getRange("E" + rigaCorrente).getValue()

  spreadsheet.getCurrentCell().setFormula('=CERCA.VERT("'+key+'";Foglio2!$A$2:$B$11;2;FALSO)');

};

It displays an error. The formula is written in the right way, if I copy the text and paste

it into another cell, it works, but in the currentcell it gives me an error. Any tips?

[Peter Berkhout]

It looks like the closing ) is missing on this line: 

var key = sheet.getRange("E" + rigaCorrente).getValue()

Op woensdag 13 september 2023 om 22:11:55 UTC+2 schreef Proiz:

[Daniel Paes]

something i have do it, its use formula in english, even if my formulas in google sheets its in my language... i dont know why, but the spreadsheet only accept the formula write from the app script in english.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/226d7bee-30b9-4d79-bbdd-fa422b131203n%40googlegroups.com.

--

Daniel Paes Ti, GS Cred +55 (46) 9918-2516  |  www.gscrd.com.br  |  dan...@gscrd.com.br Rua Itacolomi 939, Centro, Pato Branco - Paraná, 85501-240, Brazil

Create your own email signature