Spread sheet formula not working

[Sarmed]

IFERROR(INDEX((2*(RC[-26]*R2C30:R7C30)/100)+(0.5*(RC[-25]*R2C30:R7C30)/100),MATCH(RC[-12],R2C27:R7C27,0),1),"0")

My spread sheet formula is n

ot giving desired value in app sheet it is showing #Value!

Please help

[Sarmed]

It is also not displaying read only value of that column of spread sheet in Appsheet

[Cale_QREW]

Hey Sarmed,

From my experience, formulas within your data source can cause some funny things to happen from time to time in your app. That may be what’s causing your issue currently. Take a look at the article below to maybe get an idea of what your formula in your spreadsheet might be doing to your app.

Link: https://help.appsheet.com/en/articles/961393-spreadsheet-formulas

Is it possible to maybe set up this formula on the app side of things?

Hope this helps!
Cale