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.