Error when using formulas


#1

I am trying to make a basic formula such as 2X4 = 8 however i constalny get an error message in the formula column

any thoughts?


#2

The multiplication symbol (×) is represented in Airtable formulas using an asterisk (*). A lowercase letter “x” will not work, which is why you are getting an error message.

In Airtable, formulas are written for entire fields, not for individual cells. If you wanted to write a formula for this field, it would be written as “2*4”—no equals sign needed.


If you’d like to know more about formatting formulas in Airtable, check out this support article.