Forum Discussion

Noadekat's avatar
Noadekat
New Member
2 years ago
Solved

ERROR BETWEEN INTEGER AND TEXT

Hello everyone,   Can you please help me with the following formula?   What I want to do is I made a column with numbers where multiple columns where summed, but there are rows which are empty. ...
  • Damian_CT_Nom's avatar
    Damian_CT_Nom
    2 years ago

    "" is a text, therefore the error. Try using:
    = if(ISBLANK([Totaal aantal fouten]), 0 , [Totaal aantal fouten])
    that should work

Damian_CT_Nom's avatar
Damian_CT_Nom
Icon for Helper I rankHelper I
2 years ago

"" is a text, therefore the error. Try using:
= if(ISBLANK([Totaal aantal fouten]), 0 , [Totaal aantal fouten])
that should work