Skip to main content

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'

)

)

)

)

 

 

 

 
I personally have no idea why the formula shared was nested and if that has something to do with it, but everything else about the formula is working.
 
It's displaying like this in the table and the interface.
 
Thanks in advance for any help provided.

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&"",

 

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&"",

 


That's an excellent tip. I never knew that. Thank you @Sho 

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&"",

 


Amazing, thank you! I really appreciate your help @Sho.

This community is the best.

Reply


Terms & Conditions