sqft and sqm columns; user can enter either

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?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!