Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 17, 2023 03:18 PM
Hi Everyone,
I'm new to Airtable and formulas and have a pretty simple formula that is displaying a hyphen as a result of a calculation of zero, instead of the number 0. I admit I borrowed the formula originally from one I found on here, but not sure why the number I've designated isn't being displayed.
It's not a true numeric calculation, but a replacement I'm using to give a numeric value to a field that also has text for ratings, i.e. 3 - Exemplary, etc., so that I can total up all the ratings from different categories and assign a value.
Here's the formula:
IF(
{Field1} = '0 - Deficient' , 0,
IF(
{Field2}
= '3 - Exemplary', 3,
IF(
{Field3}
= '2 - Accomplished', 2,
IF(
{Field4} = '1 - Developing', '1', 'Out of range'
)
)
)
)
Solved! Go to Solution.
Aug 17, 2023 04:50 PM - edited Aug 17, 2023 05:48 PM
It seems that in the interface, if a numeric 0 is returned in a string field, it is treated the same as FALSE() or BLANK() (I guess it's a bug).
If you add an empty character ( &"") to output as a string, it displays correctly.
{Field1} = '0 - Deficient' , 0&"",
Aug 17, 2023 04:50 PM - edited Aug 17, 2023 05:48 PM
It seems that in the interface, if a numeric 0 is returned in a string field, it is treated the same as FALSE() or BLANK() (I guess it's a bug).
If you add an empty character ( &"") to output as a string, it displays correctly.
{Field1} = '0 - Deficient' , 0&"",
Aug 17, 2023 05:46 PM
That's an excellent tip. I never knew that. Thank you @Sho
Aug 18, 2023 10:42 AM
Amazing, thank you! I really appreciate your help @Sho.
This community is the best.