Help

Error when using formulas

Solved
Jump to Solution
2924 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_Czertok
4 - Data Explorer
4 - Data Explorer

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?

1 Solution

Accepted Solutions
Katherine_Duh
10 - Mercury
10 - Mercury

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.

Screen Shot 2016-03-08 at 1.41.06 PM.png
3799f2d15e5c11147339cfb6713d66a8b9392adc.png

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

See Solution in Thread

1 Reply 1
Katherine_Duh
10 - Mercury
10 - Mercury

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.

Screen Shot 2016-03-08 at 1.41.06 PM.png
3799f2d15e5c11147339cfb6713d66a8b9392adc.png

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