Replace Null Results with a "0"

Platform discussions
1

I need to use the results of a calculation in one column for a subsequent calculation; however, some results are null. How can I replace those null/blank results with a “0”? Is this possible?

2

Hey Stephen!

Charlotte here for the monday team! :wave: Happy to help with this! :blush:

To confirm, you are looking for the calculation from a formula column to show a 0 if the result is null, right? Are you using an “IF” formula function?

If so, you can add a comma then “0” at the end of the formula to mean “if the answer is not __, then return “0” instead of a blank”.

Let us know if this helps or if you have any further questions! You can also send the monday.com page a DM on any of our social media platforms and we can help you there!

3

You can use the IF function to do this. Just wrap your calculation in an IF statement like this:

=IF(ISBLANK(A1), 0, your_formula_here)

This formula checks if cell A1 is blank, and if it is, it returns 0; otherwise, it calculates your formula.

4

Thank you, both, for your replies. Neither formula does what I’m looking for, however. To be more specific, I have a column where I have the formula:

WORKDAYS({Hold Start}, {Hold Stop})

What I am trying to do is have that formula return a “0” is the result is null/blank. I’m sorry if this is a basic question. This is all very new to me.

Steve

5

Good morning! Thank you for your reply. I added to the chain to be more specific about what I am trying to do, but I’m not sure if you will receive a notification.

I have a column where I have the formula:

WORKDAYS({Hold Start}, {Hold Stop})

What I am trying to do is have that formula return a “0” is the result is null/blank. I’m sorry if this is a basic question. This is all very new to me.

Thanks for any help you can provide.

Steve

6

Hi Stephen,

Try

IF(WORKDAYS({Hold Start}, {Hold Stop})="",0,WORKDAYS({Hold Start}, {Hold Stop}))

What if we could break free of the Formula column and write formulas that update any type of column? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.