I have a board with 3 mirrored columns. I need to be able to SUM these columns in a formula. I can do that if they are filled with some numbers, but I get an error if one is blank? Suggestions?

# Mirrored Columns in Formulas

Hi Wyrobot. I have created an example and I was able to sum up 3 mirrored columns with some columns without values. I have used the sum function available in the formula column. Strange the error you are getting. This operation should be straightforward.

Below the board I have configured:

Let me try this again. That’s exactly what I’m trying to do, but if a field is blank, there’s an error.

Here’s a related example - I have a simple IF statement - e.g. If the Days column is blank or = to “”, then enter “is zero” - just a simple placeholder, but I get an error.

The three referenced columns are indeed number type columns?

This is strange. I did something similar on my side with different results:

I think you should reach out Monday support to take a closer look in your board.