set cell formula refers to another worksheet via javascript google docs

Kreol2013 · March 29th, 2012, 08:33 AM

Sorry for my English. Simply using a Google document
I'm trying to google docs to prescribe the formula by javascript
There are 2 pages on one of these generic data, the second by the formula refers to the 1st Sheet
formula that's the plan.

Code:

=(ARRAYFORMULA(SUMIF('form'!$C:$C&'form'!$B:$B;$A2&$N$1;'form'!E:E)))
='sheet1'!$G10
=((('Тарифы'!$B$3)*C5)+(E5*('Тарифы'!$D$4))+(F5*('Тарифы'!$C$4))+(O5*('Тарифы'!$B$3)))-S5+T5-R5-Q5
=AVERAGE((ARRAYFORMULA(SUMIF('form'!$C:$C&'form'!$H:$H;$A13&O$1;'form'!$K:$K)))+(ARRAYFORMULA(SUMIF('form'!$C:$C&'form'!$H:$H;$A13&O$1;'form'!$L:$L)))+(ARRAYFORMULA(SUMIF('form'!$C:$C&'form'!$H:$H;$A13&O$1;'form'!$M:$M)))+(ARRAYFORMULA(SUMIF('form'!$C:$C&'form'!$H:$H;$A13&O$1;'form'!$N:$N))),(ARRAYFORMULA(SUMIF('form'!$C:$C&'form'!$H:$H;$A13&O$1;'form'!$O:$O))))

how to write the same thing in the javascript?
in guglhelpe have not found the answer
Formulas of this nature a lot, so it is advisable to paint.
Новинка! Нажмите на слова вверху, чтобы

Kreol2013 · March 29th, 2012, 03:33 PM

when you enter a formula that's so

Code:

sheet.getRange(2, 1).setFormula('=(ARRAYFORMULA(SUMIF('form'!$C:$C&'form'!$B:$B;$A4&$N$1;'form'!E:E)))');

we get an error: Missing) after argument list.