If blank formula

Platform discussions
,
1

Hi,

I have been struggling with this formula. I want to check for empty cells first, then if Cumulative Visible Emission Event Time (seconds) is equal or bigger than zero, set status to PASS. Otherwise set status to FAIL.

I have tried different ways but nothing has worked.

IF({Cumulative Visible Emission Event Time (seconds)}=“”,“”)
IF({Cumulative Visible Emission Event Time (seconds)}>0,“PASS”,FAIL")

image
image1332×855 24.5 KB

Thanks!
Norma Osorio

2

Hi @norma0485 , Try using the AI formula help within the column. After refining the prompt a few times, it gave me this formula which I think is achieving what you’re after. Give it a try.

IF(OR({Cumulative Visible Emission Event Time (seconds)} = "", ISBLANK({Cumulative Visible Emission Event Time (seconds)}), NOT(ISNUMBER({Cumulative Visible Emission Event Time (seconds)})), {Cumulative Visible Emission Event Time (seconds)} < 0), "FAIL", "PASS")

2024-11-12_12h49_31
2024-11-12_12h49_31581×375 10.6 KB

3

Hi @norma0485,

If {Cumulative Visible Emission Event Time (seconds)} is a Numbers column, then based on my test, either the content returns true to ISNUMBER or not. That’s the only necessary test to know if the column is empty.

Therefore, try:

IF({Cumulative Visible Emission Event Time (seconds)}>0,
     "PASS",
     IF(ISNUMBER({Cumulative Visible Emission Event Time (seconds)}),
         "FAIL", 
          ""
     )
)

 
 

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.

4

Hi,
I modified the formula to show empty cell if no number instead of fail.

IF(OR({Cumulative Visible Emission Event Time (seconds)} = “”, ISBLANK({Cumulative Visible Emission Event Time (seconds)}), NOT(ISNUMBER({Cumulative Visible Emission Event Time (seconds)})), {Cumulative Visible Emission Event Time (seconds)} < 0), “”, “PASS”)

image
image851×1147 32.2 KB

I want to add another conditional to test for Cumulative Visible Emission Event Time (seconds)} >60 the fail.

Could you help me? Right now, is passing everything.

5

Try:

IF(AND({Cumulative Visible Emission Event Time (seconds)}>0,{Cumulative Visible Emission Event Time (seconds)}<=60),
     "PASS",
      IF(ISNUMBER({Cumulative Visible Emission Event Time (seconds)}),
     "FAIL", 
      ""
      )
)

 

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.