Hi team,
I have this formula in the Spreadsheet to calculate years from initial date until Today(), it works perfect:
field โSpreadsheet formulaโ in AppSheet:
DATEDIF(RC[-1], TODAY(),โYโ)
Every new record, appsheet puts the formula, perfectly.
Butโฆ when the formula is little bit complex, like bringing the initial date from another sheet in the spreadsheet, appSheet doesnโt put anything at allโฆ leave the cell in blank. This is the formula thatโs seems to give issues:
and this is what AppSheet puts in the field โSpreadsheet formulaโ:
=ArrayFormula(DATEDIF(RC[-1], VLOOKUP(RC[-8], {AtencionAmbul!C1:C1, AtencionAmbul!C9:$I}, 2, false),โYโ))
I have regenerated the columns, nothing. Put the old formula again, and works fineโฆ
I would send this to support@appsheet.com as it seems to be a bug.
I suggest that taking this occassion, get out of the spreadsheet formula, which is not recommended to use in spreadsheet Appsheet app is based on. I reckon you can reproduce the same function by Appsheet expression instead of spreadsheet formula.
If I recall correctly, this could also be a fundamental thing with spreadsheets formulas within AppSheet - I believe this is to explicitly prevent AppSheet from being ever able to access data outside of the scope that it is allowed within the app.
If I remember this correctly, sheet formulas as TODAY(), NOW() etc. are recalculated virtually on your spreadsheet and those updates are not reflected via API what your app is using. You can easily test this if you use NOW() on your spreadsheet. If you set the update as On change and every minute, you will see the new timestamp from your spreadsheet, but it doesnโt change the timestamp in your app even you sync the app.
User | Count |
---|---|
17 | |
14 | |
8 | |
7 | |
4 |