Null/Blank in Formulas

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},

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.


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

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

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.

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.


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