When using Google Sheets as the data source for an app, some calculations might not be performed due to incompatibilities between Microsoft Excel and Sheets. Here's a list of functions that work in Sheets but not in Excel.
- ADD
- ARRAYFORMULA
- CONCAT
- CONTINUE
- COUNTUNIQUE
- DETECTLANGUAGE
- DIVIDE
- EQ
- FILTER
- GOOGLEFINANCE
- GOOGLETOURNAMENT
- GOOGLETRANSLATE
- GT
- GTE
- IMAGE
- IMPORTDATA
- IMPORTFEED
- IMPORTHTML
- IMPORTRANGE
- IMPORTXML
- JOIN
- LT
- LTE
- MINUS
- MULTIPLY
- POW
- QUERY
- SORT
- SPARKLINE
- SPLIT
- TO_TEXT
- TO_PERCENT
- TO_DOLLARS
- TO_DATE
- UMINUS
- UNARY_PERCENT
- UNIQUE
- UPLUS
Note:
Please be advised that your Google Sheet has to be "Excel-conform" in order to guarantee the full functionality of your app as your Sheet is passed to the app in .xlsx format.
What helps in troubleshooting is to export the Google Sheet as an .xlsx file and then check how Excel handles it when you open that file.