Problem with COMPUTED_VALUE for ArrayFormula on Google Sheet

[hien_nguyen]

Hi all,

I have a problem with my app if I want to set an Arrayformula on Google Sheet to calculate.
Normally I often remove the formula on a spreadsheet on Appsheet, but sometimes I regenerate columns AppSheet auto-set COMPUTED_VALUE on it.
How to prevent Appsheet set COMPUTED_VALUE on columns having an array formula?
Pic#1: The formula which I set on a SpeadSheet.

Pic#2: Appsheet Auto set value COMPUTED_VALUE on SpeadSheet Formula after Regenerated Columns.

Pic#3: The ArrayFormula error updating value from Appsheet.

Please help,

Thanks

[Marc_Dillon]

hien_nguyen:

but sometimes I regenerate columns AppSheet auto-set COMPUTED_VALUE on it.> How to prevent Appsheet set COMPUTED_VALUE on columns having an array formula?

You can’t. Just delete it after regenerating.

[sathishk]

Good Morning , Is there any new solution for this now?

Is deleting the COMPUTED_VALUE text from the ‘Spreadsheet Formula’ is the the only way for Arrayformula in google sheet? thanks