Skip to main content

I have one table Evals where I have a true or false question that I want to count in another table called Eval Summary. In Evals, I created two formula fields that seem to be working fine:


IF({Would you attend a similar conference next year?}=“True”,1," ")


IF({Would you attend a similar conference next year?}=“False”,1," ")


I’ve linked the Evals to the Eval Summary table with linked field and created a rollup field linking to that table and formula field with SUM(values). But it’s just giving me NaN and I can’t really figure out why.


Any help is appreciated and thanks in advance!

Get rid of the ‘else’ portion of that statement — that is, the ‘" "’ part the function reads


IF({Would you attend a similar conference next year?}="True",1)

Whenever an expression can be evaluated to either a number or a string, as your examples are, Airtable forces all responses to be text; in other words, you’re not summing 1 + 1, you’re summing '1' + '1'. Since you can’t add text + text, you get the Not a Number error…

Get rid of the ‘else’ portion of that statement — that is, the ‘" "’ part the function reads


IF({Would you attend a similar conference next year?}="True",1)

Whenever an expression can be evaluated to either a number or a string, as your examples are, Airtable forces all responses to be text; in other words, you’re not summing 1 + 1, you’re summing '1' + '1'. Since you can’t add text + text, you get the Not a Number error…


Thanks for your help! I really appreciate it.

Reply


Terms & Conditions