Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Building a formula from a formula (square footage calcs

Topic Labels: Formulas
246 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I have a weird one. I’m building a table of square footage calculations from a census of product types.

I have a single select field for unit dimensions, like 10x20. And another field of the quantity of those units.

So in an example of a 10x20 with 10 in the qty field, the proper formula construction would be =102010 for an output of 2000.

Screen Shot 2021-01-19 at 9.31.06 AM Screen Shot 2021-01-19 at 9.31.14 AM

I built a formula as a test to see if I could replace the x with a * to get closer to automating the math, but I can’t find a way to get that into a formula that then parses the * as a multiplier and does the full calculation.

I’m missing some kind of step to get there. Any advice?

1 Reply 1

I like your thinking. It’s a way of getting to the answer that I wouldn’t have thought of. You need an Airtable function like EVALUATE() that would take a string and evaluate as a formula. Would be cool.

Here’s another way to get what you want, though decidedly less elegant.

image