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")
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")
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.
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.
GCavin
(Gilles Cavin - Reinventing Formulas in monday.com)
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.