Reference cell to another sheet cell which has array formula?

1
votes

I tried to use indirect but it does not work as follow:

=ArrayFormula(indirect(Frmla!B1))

Sheet name: Frml, cell B1 has the array formula phrase.

Also tried to index the whole array formula but I got an error too

=index(Frmla!B1)

Sheet URL:

https://docs.google.com/spreadsheets/d/1SOsZX-Vrowxc3XlcaeH_7o3FYYFSJY3Wcsagkj5F2Eo/edit?usp=sharing

1
google-sheetsarray-formulasgoogle-sheets-formula

1 Answers

0
votes

try: =ArrayFormula(indirect("Frmla!B1"))