Array Sheet formulas ans AppSheet: Excel vs G...

expressions
(Michael) #1

Array Sheet formulas ans AppSheet: Excel vs Google Sheets

If I use an array formula in an Excel workbook, AppSheet does not read the values of the expression. All of the expressions evaluate to #N/A. If I copy the workbook to a Google Sheet, AppSheet reads the values of the expression properly.

Is there any way around this apparent limitation? Because the Excel workbook is connected to a local XML database, it is imperative that this workout with Excel rather than Google Sheets as GS cannot connect to the XML DB.

(Aleksi Alkio) #2

Adding @Philip_Garrett_Appsh

(Philip Garrett) #3

@Michael

Can you provide: 1. Your account id 2. The app name 3. The table name 4. The column name with the formula

(Michael) #4

@Philip_Garrett_Appsh I’ve since removed the column with the array formula from the app and used a not so elegant workaround. I’d love to use the array if possible but…

I seem to have the same issue with a simple vlookup. The expression evaluates correctly in the Excel workbook but, AppSheet evaluates to #N/A.

  1. ID 352471 2. Flavor Database 3

Recipes 4. Rating