Problem with COMPUTED_VALUE for ArrayFormula on Google Sheet

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

0 2 159
  • UX
2 REPLIES 2

You can’t. Just delete it after regenerating.

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

Top Labels in this Space