我有以下腳本，我收到錯誤SyntaxError: missing ) 在參數列表之后（第 9 行，文件“tracker.gs”）function tracker() { var spreadsheetIDs = ["myID1","myID2"]; var i=0,sheet,thisID=""; for (i=0;i<spreadsheetIDs.length;i+=1) { thisID=spreadsheetIDs[i]; sheet = SpreadsheetApp.openById(thisID).getSheetByName('History'); sheet.getRange("A2").setFormula('=IF(Login!G3=0,"",QUERY(ARRAYFORMULA({IMPORTRANGE(Core!B1,"History!A1:AC4000");IMPORTRANGE(Core!B1,"History!A4001:AC8000");IMPORTRANGE(Core!B1,"History!A8001:AC12000")}),"Select Col1, Col2, Col3, Col4, Col5, Col6, Col7, Col8, Col9, Col10, Col11, Col12, Col13, Col14, Col15, Col16, Col17, Col18, Col19, Col20, Col21, Col22, Col23, Col24, Col25, Col26, Col27, Col28, Col29 where Col2 ='"&Login!C2&"'",0))'); };};我已經確定它在'"&Login!C2&"'周圍有撇號導致公式末尾出現問題，但這是 QUERY 函數中的一個關鍵標準。我該如何解決這個錯誤？
在 setFormula 中的公式中使用撇號 (')
慕斯709654
2023-04-20 10:24:00
