Data not transferred to appsheet

Hi, will appreciate help on this, there is a google sheet formula in the source
Here is how the app looks like

But the Replenishment(MOQ Qty) is still not appearing when there is data in the source? I have made the app read-only and the data field for the column I am asking about,number so are the ones that are included in the formula. Just to clarify, there is also no error warnings given and I have regenerated the source multiple times yet it is still showing the same error.
Does anyone know the reason?

Try computing the value in the app with an expression rather than with a formula in the spreadsheet.


Thank you! It worked! :smiley: