Is there any AppSheet formula to calculate sum based on input values. I have tried it but it is only work in next sync when using google sheet as a database.
1 Like
Yes, I have a form for entering 3 progress percentages respectively 30%, 50%, and 20%. it shows in the button format. I need to calculate sum & save the total based on the input percentages
I have the same trouble as you
1 Like
If both of you have the same situation, just remember that real columns’ AppFormulas won’t get updated until you update the whole row
1 Like
It seems that when you create a new row with a formula that sums all the rows and the current row, you have to wait for the app to update and then manually click on edit to apply the formula. I believe that this behavior is a bug, rather than an intentional feature.
1 Like
If your Sum column is a real one instead of a Virtual one, for sure it’s intentional, and I count on that behaviour in many ways
Dear Appsheet team. Please give careful consideration to this case. The issue is that when I create a new line, Appsheet fails to recognize it until I sync it again. As a result, when using functions such as sum() or select() that calculate numbers (including the current row), the calculations are incorrect. This error seems to occur only when Appsheet updates the auto-sync feature. Although this feature is not enabled for my account, the error persists.
You still don’t tell us if your column is Virtual or not, which is the point of all of this
My columns are not virtual, and I contact Appsheet to help me fix them but now nothing has changed after 7 days
So you are experiencing the expected behaviour
1 Like