Hey Airtable community,
Here’s my formula. The formula itself works, but I want to format the output as a currency. Why is Airtable saying it’s not a number?
IF({Score} = 1,
"75",
IF({Score} = 2,
"120",
IF({Score} = 3,
"180",
IF({Score} = 4,
"240",
IF({Score} = 5,
"225"
)
)
)
)
)
Any help is much appreciated!
With warm regards,
Alex
Best answer by ScottWorld
When you put your numbers in quotation marks, that tells Airtable that it is a string of text. So, you’ll want to remove the quotation marks from your numbers.
+33When you put your numbers in quotation marks, that tells Airtable that it is a string of text. So, you’ll want to remove the quotation marks from your numbers.
When you put your numbers in quotation marks, that tells Airtable that it is a string of text. So, you’ll want to remove the quotation marks from your numbers.
Silly me. Thanks so much, Scott! Solved.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
