This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Problem with COMPUTED_VALUE for ArrayFormula on Google Sheet

Posted on 12-04-2021 07:57 AM
hien_nguyen
Silver 2
Silver 2
Reply posted on --/--/---- --:-- AM

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.

3X_a_f_af91dc286444642ff7191b5f40baaa89b5f12268.png

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

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

Please help,

Thanks

0 2 275
Topic Labels
  • UX
0 Likes
2 REPLIES 2
Top Labels in this Space