I have created a simple app that allows entries for new projects.
In a text cell, I want to create a formula that automatically multiplies the values for two other cells. For example, I have length and width input text boxes when filling out a new form, and want a third box for Area below it that automatically multiplies length and width and won't require a separate text entry. I have tried "=" formulas, like in excel, but none seem to work.
If anyone knows how to do this, it would be great. Thanks.