Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Can't figure out why formula result isn't a number

Topic Labels: Formulas
Solved
Jump to Solution
1445 3
cancel
Showing results for 
Search instead for 
Did you mean: 
kerosity
4 - Data Explorer
4 - Data Explorer

Here’s the formula I’m using:

IF(
{Number Field 1}!=’’,
({Number Field 1} / {Weight (number field)} + {Number Field 2}),
IF(
{Number Field 2}!=’’,
({Number Field 1} / {Weight} + {Number Field 2}),
‘’)
)

My goal with the formula:

I’m trying to reach an inventory count as a result of this field.

A) If the inventory count is low, we can manually enter the exact count of the part into “Number Field 2”

B) If the inventory count is higher, we get an approximate count based on weight. So we enter the weight into “Number Field 1” of the total part. It calculates total weight vs the part weight to give us a part count.

C) If for some reason during the process we weigh the inventory, but find more of that part, we sometimes add the exact count on after. So if there’s numbers in each of the field, we need the formula to account for both.

The result of the formula “works”, as in the numbers are right. But it isn’t a number output. So for us to use the result of the field, or format the output, it isn’t working for us.

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

You’ll need to remove the final quotation marks ('') from your formula.

Unlike other programming languages where you can explicitly set the field type that a formula field should result in, Airtable AUTOMATICALLY CHOOSES the field type based on ALL the possible responses that your formula field might yield.

In other words, if ALL of your possible responses result in a number, then Airtable’s formula will result in a number field. Otherwise, it results in text.

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

See Solution in Thread

3 Replies 3
ScottWorld
18 - Pluto
18 - Pluto

You’ll need to remove the final quotation marks ('') from your formula.

Unlike other programming languages where you can explicitly set the field type that a formula field should result in, Airtable AUTOMATICALLY CHOOSES the field type based on ALL the possible responses that your formula field might yield.

In other words, if ALL of your possible responses result in a number, then Airtable’s formula will result in a number field. Otherwise, it results in text.

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

When I was building this formula, I tried doing that and got an error. So I thought it was critical to have that there. But I realized, the error was coming from the remaining “comma” after removing those quotes.

Your solution worked! Thank you!

Ah, right! Remove the comma AND the quotes.