Formula with 2 columns numerical input

[shakeel_kader]

Hi , I want to create a formula for BMI ( Body mass index) when I input the weight and height to generate an answer that will populate the BMI column ? How should i do this ? the formula is BMI = weight (kgs) /height (m2) . Thanks

[Aleksi]

Try… [WEIGHT]/POWER([HEIGHT],2)

[shakeel_kader]

Thank you. Where do i put this formula in appsheet?

[Aleksi]

Use it with the App formula field. Then it will recalculate it every time if you open & save that record.

[shakeel_kader]

thank you. it worked beautifully

[Aleksi]

You’re welcome