Help

Getting NaN in rollup field, stuck on how to fix it

Topic Labels: Formulas
1253 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

2 Replies 2

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.