Google Sheet does not update values from App formula

[Poovich]

I have a product table which basically contains product id, quantity, price, and total value.

At the beginning, there are values in my google sheet, except the “Total Value” column. To get the Total Value, I put [Quantity]*[Price] in App formula in the “Total Value”, then click sync app (the arrow button on the top right corner).

However, the “Total Value” column is not updated until I go to one-by-one product and click save to make the numbers show up in the “Total Value” column.

Is there a better way to do this? Please suggest

[JuneCorpuz · Accepted solution]

Poovich:

However, the “Total Value” column is not updated until I go to one-by-one product and click save to make the numbers show up in the “Total Value” column.

Because the app formula only applies when you are opening a form.

Poovich:

Is there a better way to do this? Please suggest

You can put the formula in your spreadsheet [Quantity]*[Price] and paste it as values once you are done.