sqft and sqm columns; user can enter either

E. Robert Shanfeld

I am looking to have an intake Form that allows a user to put in numbers in square feet (sqft) or square meters (sqm). I don't want to ask the user to enter both. However, in my Sheet, I'd like to have both fields with both sqft and sqm, regardless of which is entered by the user. Any suggestions?

Paul H

Have the user enter the "Area" and choose sqft or sqm from a drop down

Paul H

Have the user enter the "Area" and choose sqft or sqm from a drop down