Null/Blank in Formulas

Platform discussions
,
1

I’m trying to see if there is a way to create a null value in the formulas, because my formulas is as follows:

if({Total (Actual)} = “”,
" ",
if({Total (Actual)} = {Total Estimate},
“Correct”,
“Error”))

So if the “Total (Actual)” column is blank, it should output a blank statement, but it just goes and proceeds to input a “Correct” or “Error” message.

2

@C_man

If {Total (Actual)} is a numeric column, try this: IF({Total (Actual)} = "0", "", ....

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday

3

so I did and it still didn’t work. What I am essentially am hoping to do is if the “Total(Actual)” is blank then the formula would not output anything, and there will be instances where it will be 0.

4

It is always a good idea to be consistent with your data, it should be either zero or blank and not both.
You could test them both, though, in your nested IF.

5

@C_man

Can you be more specific about “it still didn’t work”?