Thank again for all the help.
I am trying to achieve something that I would like to see if you cal help me with.
I have a Column = Sub Total
the following column refers to discount which I have prefixed values as Enum. (2%, 4%, 6%, 8%, 10%)
The following column is a Total which I want to be calculated (Sub Total)-(Discount) automatically once the user selects one of the previous mentioned enum value.
Appsheet is not calculating this automatically, my guess is because the form is not saved and synced
is there any way to obtain this calculation automatically before the form has been saved?