Hello,
I’m hoping someone can help with a formula issue. Im using a If(Or) formula and it works fine with the first 2 conditions but when I add a 3rd one is not. Im not sure what I’m doing wrong.
This is the formula with the first 2 conditions:
IF(OR(DAYS({Fingerprinting Due Date},TODAY())>=300),(DAYS({Central Registry Due Date},TODAY())>=300),“Y”,“N”)
and this is the result:
When I add another criteria:
IF(OR(DAYS({Fingerprinting Due Date},TODAY())>=300),(DAYS({Central Registry Due Date},TODAY())>=300),(DAYS({TB Test Due Date},TODAY())>300),“Y”,“N”)
It returns “true” everywhere as opposed to the required “Y” or “N” values.
Hello @Yanci.tamayo welcome to the Community!! I will try and help, but let me know if it works!!
You’re super close! The issue here is with the syntax of your formula. When you’re using IF(OR(...), "Y", "N"), all the conditions inside OR() must be within the same set of parentheses, like this:
Corrected Formula:
plaintext
CopyEdit
IF(OR(DAYS({Fingerprinting Due Date}, TODAY()) >= 300, DAYS({Central Registry Due Date}, TODAY()) >= 300, DAYS({TB Test Due Date}, TODAY()) >= 300), "Y", "N")
What I think went wrong:
You were placing each DAYS(...) condition in its own set of parentheses inside the OR() function, which actually breaks the logic and causes monday.com to return true instead of the expected "Y" or "N".
Let me know if you want to add even more conditions or turn this into a more dynamic formula!
Corrected Formula: