LinkedIn
Twitter
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…
