Hello,

This question is mostly for those who **use Google Spreadsheet** for their data, I think.

For reasons of transferring computing time from appsheet to the google spreadsheet, I’ve come to write some formulas in the spreadsheet that go on these lines:

**- the formulas are written on the very first row of the spreadsheet and look like this:**

**={“Name of my Column”;ArrayFormula(my formula)}**

Most work just fine and spreadsheet recognizes these formulas and the Column Name just fine.

However, there are **some** that **don’t seem to be recognized by appsheet**, but in a very strange … half way … way.

So the **only thing** that I find **special about them is that they contain a query()** as far as I can tell.

Appsheet recognizes the Column Name just fine.

However, in the **“Auto Compute” field** of the column, on the **“Spreadsheet formula” line** it generates this " **“COMPUTED_VALUE”** " text. And **when I add data through the App**, in the spreadsheet it actually fills in the cell with the actual words “COMPUTED_VALUE”…and obviously, that’s not good as it **interrupts the ArrayFormula**.

Now **what is even stranger**, is that if I delete that value from the “Spreadsheet formula” line in Appsheet and save, it doesn’t fill it back in and so when I add data through the App now, the **ArrayFormula works fine**.

**BUT**, that’s not a long term solution because **if I Regenerate the Structure of the Table**, then **Appsheet again fills in that field with “COMPUTED_VALUE”** and I would have to remember to always go back there and delete it before adding any new data to that table through the App.

So, any Ideas about what to do here?

Or what’s the logic of it?

- how come it doesn’t recognize the formula?

Just in case,**here is the formula**itself:

={“Name of My Column”;

ArrayFormula(

if(A2:A="","",

iferror(

vlookup(A2:A,

query({Times!A2:A,Times!C2:C,Times!J2:J,Times!Q2:Q}, "select Col2, sum(Col3) where Col1 <> ‘’ AND Col4 = ‘CNC’ group by Col2 ", 0),2,false),

“0”)))

}

- how come it forces this text “COMPUTED_VALUE” into the spreadsheet?

Thank you,

Sorin