Formula is not working for conversion

[Odiez]

I have a google sheet hat use formulas in the headers, and in my app most of them is working, but not the currency convert part like this.

={"R Per Maand";ARRAYFORMULA(IF(LEN(B2:B),I2:I*GOOGLEFINANCE("CURRENCY:USDZAR"),))}

and give error ="COMPUTED_VALUE".

How can I fixed this 

[AleksiAlkio]

Remove the "formula" from that column's sheet formula field.

[Odiez]

When I take the formula out of headers, and add it in appsheet, it gives error "Unable to find function 'GOOGLEFINANCE'"

[AleksiAlkio]

Sorry, what I mean.. take it away from AppSheet, not from gSheet.

[Odiez]

Ok, I do not have the formula in appsheet, only in my google sheet, but givers the same error =COMPUTED_VALUE". 

[Odiez]

When running from google sheet is working, but when I run it from appSheet app, it gives error ="COMPUTED_VALUE" with this "Array result was not expanded because it would overwrite data in L3." There is nothing in L3 till I run it from appsheet app.

[AleksiAlkio · Accepted solution]

It means the app tries to save a value to it.. set the column as read_only (not editable) and double check that you don't have anything in the sheetformula field in that column's definition.

[Odiez]

Thank you, did find a formula in it, and now it is working

[AleksiAlkio]

Excellent!