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?
Solved
Error when using formulas
Best answer by Katherine_Duh
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.
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.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.