IF statements checking for an empty numbers collumn

Platform discussions
, ,
1

Utilizing a formula column, I am running an if statement to check if a numbers column is blank. IF it is blank, the script should return nil “”. Otherwise, it should run my formula.

My formula works perfectly for text columns, but not a numbers column.

The formula is just adding the number is the numbers column to todays date and formatting it.

This is my code

IF(OR({Due Days} = '', ISBLANK({Due Days})), "", FORMAT_DATE(ADD_DAYS(TODAY(), {Due Days}), "dddd MM/DD/YY"))

2

Hi Brock,

When empty, a number column returns 0, so if your objective is not to return anything when empty, then this should work:

IF({Due Days} = 0, "", FORMAT_DATE(ADD_DAYS(TODAY(), {Due Days}), "dddd MM/DD/YY"))

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

2 Likes
3

Thank you that worked, it’s strange because sometimes I want the days to be 0 as in, I want them to do it right away. And yet when I select 0 it still works.

5

Hi,
I am facing similar problem

IF(OR({Q1 Valor final}=“”, {Q1 Valor final}=NULL, {Q1 Valor final}= 0), “VAZIO”, “GERAL”)

image
image314×222 6.21 KB

As you can see, when column is empty MONDAY calculates as a filled

@mondayman @Themondayman please help me!!!

6

Hi @BeaCruz,

Never seen NULL used in monday, but this syntax should do it:

IF(OR({Q1 Valor final}="",{Q1 Valor final}="0"), "VAZIO", "GERAL")

Note than 0 won’t work for a text column, you need to use “0”.

 

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.

7

Thanks so much @GCavin

How {Q1 Valor final} is number column I didn´t realize that I should insert “”