0

I found this script that realized FORMULATEXT's excel function in google. 

    function FORMULATEXT(A1Notation) {
  return SpreadsheetApp.getActive().getRange(A1Notation).getFormula();
}

But problem is for use it you need use quotations for reference like this

=formulatext("A1")

And link in formula didn't change when you move it in other cell. How can i upgrade this script to fix it?

tehhowch
  • 9,221
  • 4
  • 23
  • 40
rusya_sk
  • 79
  • 1
  • 2
  • 10
  • Use `CELLFORMULA` as described (https://stackoverflow.com/a/37341868/1330560) – Tedinoz Jan 30 '19 at 10:19
  • i would like, but it doesn't work inside other formula. – rusya_sk Jan 30 '19 at 10:32
  • You said the problems with `formulatext` were 1) "use quotations for reference" and 2) "link in formula didn't change when you move it in other cell". Well, `CELLFORMULA` fixes both of those problems. Whether it works inside other formula is a different issue altogether. Best that you read [How do I ask a good question?](https://stackoverflow.com/help/how-to-ask) and then create a new question. – Tedinoz Jan 30 '19 at 13:03

0 Answers0