.setFormula() and received error missing ) argument list

by

You dont need single quotes ' around Sheet1.

Try

me.getRange('B8')
    .setFormula('=arrayformula(concatenate(filter(Sheet1!E2:E,Sheet1!E2:E<>"") & ", "))"');

If you still need it, you need to escape it with backlashes like this \':

me.getRange('B8')
    .setFormula('=arrayformula(concatenate(filter(\'Sheet1\'!E2:E,\'Sheet1\'!E2:E<>"") & ", "))"');

Reference:

String ยง Escape notation

More Related Contents:

  1. ultimate short custom number formatting – K, M, B, T, etc., Q, D, Googol
  2. ArrayFormula is breaking the getLastRow() funtion. Possible workarounds?
  3. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  4. Selecting the last value of a column
  5. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  6. Refresh data retrieved by a custom function in Google Sheet
  7. How do you create a “reverse pivot” in Google Sheets?
  8. How to protect the Apps Script code in a Google spreadsheet?
  9. Create Google Calendar Events from Spreadsheet but prevent duplicates
  10. Google Apps Script: How to set “Use column A as labels” in chart embedded in spreadsheet?
  11. Retrieving Google Sheets cell border style programmatically
  12. Determining the last row in a single column
  13. Cannot find method getRange(number,number)?
  14. How do I add formulas to Google Sheets using Google Apps Script?
  15. You do not have permission to call openById
  16. Deleting rows in google sheets using Google Apps Script
  17. Delete a row in Google Spreadsheets if value of cell in said row is 0 or blank
  18. Single Google Form for multiple Sheets [duplicate]
  19. Adding Buttons To Google Sheets and Set value to Cells on clicking
  20. Custom function throws a “You do not have the permission required to setValue” error
  21. Margins parameters for Google spreadsheet export as PDF
  22. Script to convert .XLSX to Google Sheet and move converted file
  23. Hidden field in a Google Form
  24. onEdit() doesn’t catch all changes
  25. How to evaluate a spreadsheet formula within a custom function?
  26. Converting .xls to google spreadsheet in google apps script
  27. Adding a property to an Html template gives error “Object does not allow properties to be added or changed”
  28. We’re sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED
  29. Custom Functions and Recalculation
  30. e.range.getA1Notation() unable to track changes caused by formula update

Leave a Comment