One of my line in google apps script function is next
mnmaSheet.getRange(9,22).setFormulaR1C1("=IFERROR(MATCH(R[0]C[-1!D:D,0);-1)")
However, after running the script result is incorrect because I always receive -1 even if the searched value is present in the sheet "Довідник".
I tried to write two brackets from both sides of sheet's name (''Довідник''), however I receive error. In addition, I tried to write codes for updating cells however it didn't work too.
Changing setFormulaR1C1(formula) to setFormula(formula) works since The given formula must be in R1C1 notation. for it to work.
The formula =IFERROR(MATCH(R[0]C[-1!D:D,0);-1) has arguments that are in A1 notation, which is why it was returning -1.