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.
Adding @Philip_Garrett_Appsh
Can you provide: 1. Your account id 2. The app name 3. The table name 4. The column name with the formula
@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.
Recipes 4. Rating
User | Count |
---|---|
39 | |
25 | |
22 | |
20 | |
15 |