SPREED SHEET FORMULA NOT WORKING IN APPSHEET

AppSheet AppSheet Q&A
1

I HAVE A PERSONAL INVESTMENT TRACKER APP IN WHICH GOOGLE SHEET FORMULA WORKS FINE IN GOOGLE SHEET BUT DOES NOT COMPUTE IN APPSHEET

GOOGLE SHEET FORMULA

=IFERROR(IFERROR(index(sort(GOOGLEFINANCE(“NSE:”&B2, “high”, today()-365, today(), “DAILY”),2,0),2,2),index(sort(GOOGLEFINANCE(“BOM:”&REGEXEXTRACT(B2,“[0-9]+”), “low”, today()-365, today(), “DAILY”),2,1),1,2)),“”)

CORRESPONDING APPSHEET R1C1 FORMAT FORMULA

IFERROR(IFERROR(index(sort(GOOGLEFINANCE(“NSE:”&RC[-10], “high”, today()-365, today(), “DAILY”),2,0),2,2),index(sort(GOOGLEFINANCE(“BOM:”&REGEXEXTRACT(RC[-10],“[0-9]+”), “low”, today()-365, today(), “DAILY”),2,1),1,2)),“”)

THIS FORMULA SHOW 52 WEEK HIGH VALUE OF TICKER WHERE(B2, IS A TICKER)

2

AppSheet does not use Google Sheet expressions.
It has its own expressions:

https://support.google.com/appsheet/table/10104782?hl=en&ref_topic=10099895,10173496,10099316,&sjid=11599606032748674198-EU

Google Sheet fields that contain formulas are not calculated.