ADDING TWO CELLS FROM THE SAME TABLE

Hello, greetings to all, I am new to appsheet and I am going crazy to be able to obtain the sum of two simple cells of the same table and update (SAVE) that calculation in another cell of the same table. Can anybody help me. From already thank you very much!

Ex.
Cash [VALUE] + Cash [VAT] = Cash [BALANCE]

0 2 172
2 REPLIES 2

I assume in your table you have 3 columns [Value], [Vat] and [Balance]. All defined as โ€œPriceโ€ type columns.

Normally, your [Balance] column would be designated as a calculated column NOT allowed to be manually edited by a user.

To do this you simply need to add the โ€œApp Formulaโ€ property of the [Balance] column this expression:

[Value] + [Vat]

Being in the App Formula property, anytime the row is edited to change [Value] or [Vat], the [Balance] column will automatically be re-calculated.

Thank you very much John, for your help, I was finally able to do it, I send you a big hug from Mar del Plata, Argentina.
Successes!
Aldo

Top Labels in this Space