Feb 28, 2016 07:26 AM
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! Go to Solution.
Mar 08, 2016 01:41 PM
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.
Mar 08, 2016 01:41 PM
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.