Error while running script

[Abhishek Waghmare]

Hey,

I'm trying to run script which can autofill column whenever sheet gets new entry in sheet. able to run basic formulas with the same script but getting error when i'm using importrange with it. Please suggest

function myfunction() {

  var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

  ss.getRange("C3").setFormula("=filter(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1ics18DtEuJi0AKKHCs85PruyRGMW0xFRca1sm0X5FgI/edit#gid=1086052575","Form responses 2!I:I"),IMPORTRANGE("https://docs.google.com/spreadsheets/d/1ics18DtEuJi0AKKHCs85PruyRGMW0xFRca1sm0X5FgI/edit#gid=1086052575","Form responses 2!G:G")=B3)");

  var lr = ss.getLastRow();

  var fillDownRange = ss.getRange(3,3,lr-1);

  ss.getRange ("C3").copyTo(fillDownRange);

}

Thankyou

Abhishek Waghmare

[Jonathan Butler]

What error are you getting?

--
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/37de26b3-c34e-4f8c-bebf-e5abdc5fdb5cn%40googlegroups.com.

[Abhishek Waghmare]

Syntax error missing ) after argument list line :3 file

You received this message because you are subscribed to a topic in the Google Groups "Google Apps Script Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-script-community/ZT6uQ8KOSoo/unsubscribe.
To unsubscribe from this group and all its topics, 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/CAE9k5yB6qxFuxUL_DtbavBqok-EOyQRYkLGR%2BYuOCL9UOAJ4rQ%40mail.gmail.com.

[Jonathan Butler]

I didn't notice the screenshots initially, my bad. It's the quotation marks. When dealing with nested quotations marks, you need to either escape the inner quotation marks, or use different quotation marks outside of the inner quotation marks. Change the double quotation marks in the setFormula function to single quotation marks on the outside.

From this

ss.getRange("C3").setFormula("=filter(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1ics18DtEuJi0AKKHCs85PruyRGMW0xFRca1sm0X5FgI/edit#gid=1086052575","Form responses 2!I:I"),IMPORTRANGE("https://docs.google.com/spreadsheets/d/1ics18DtEuJi0AKKHCs85PruyRGMW0xFRca1sm0X5FgI/edit#gid=1086052575","Form responses 2!G:G")=B3)");

To this

ss.getRange("C3").setFormula('=filter(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1ics18DtEuJi0AKKHCs85PruyRGMW0xFRca1sm0X5FgI/edit#gid=1086052575","Form responses 2!I:I"),IMPORTRANGE("https://docs.google.com/spreadsheets/d/1ics18DtEuJi0AKKHCs85PruyRGMW0xFRca1sm0X5FgI/edit#gid=1086052575","Form responses 2!G:G")=B3)');

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CABMz42%3Dqtgvq1nR%2B%3DhH9evTuUnGj2%3DtHp6fBF4mqSMRBO%3DgtwQ%40mail.gmail.com.

[Abhishek Waghmare]

Ok ok..

Thanks man 👍

Let me check if it's working.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAE9k5yCWK2sDgo8TsNyQ6zaVtiJu5%2BrdQLEzn52XMCm9vKDjVw%40mail.gmail.com.