formulas doesnt work when updating data from external source

I'm using Appsheet integration to extend the functionality in forms.

I encountered a problem when trying to use the SUM formula - when a data is updated inside the columns from appsheet or another source (i only updating numbers) the formula in smartsheet doesn't recognise it and when trying to sum the numbers it shows as " 0" like the columns are empty

any suggestions on how this can be solved?


Best Answer