Avoid 'COMPUTE VALUE'

[desmond_lee]

Hi All

I have a formula at the sheet and everytime with I add column this error shows up. I remove it and I regenerate again it shows up again. How do I remove this message

[Marc_Dillon]

That’s not an error message. It’s just letting you know that the value is computed by the spreadsheet.

You can delete it, then save, and it’ll be gone. But it will come back every time you regenerate, as long as the formula remains in your spreadsheet. But it’s not a big deal.

I like to use arrayformulas on the header row for columns that need spreadsheet formulas. This way Appsheet doesn’t even know it’s there.

[desmond_lee]

=QUERY(ARRAYFORMULA(IFNA(IF(LEN(A:A),VLOOKUP(A:A,‘Pending Audit Code’!B:E,4,0),))),“SELECT Col1 LABEL Col1 ‘AUDIT CODE’”,1)

this kind of formula is detected

[Giuseppe_Nugara]

As Marc said you can put it in the header and Appsheet doesn’t detect it :

=Arrayformula({“AUDIT CODE”,ARRAYFORMULA(IFNA(IF(LEN(A:A),VLOOKUP(A:A,‘Pending Audit Code’!B:E,4,0),)))})