Solved: Formula is not working for conversion - Page 2

Odiez · 07-01-2023 06:45 AM

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

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.

View solution in original post