Conditional IF with Date Check


I am a little confused with exactly how to write an IF statement that checks that all three of the following conditions are true:

  1. {Status} = “”
  2. {Replacement Required} = “Yes”
  3. IF(NOW() > WORKDAY({Date Created},2)

I have the first two worked out, but when I try to add the third condition I am struggling to get it to work.

Any assistance gratefully received.

Try something like this:
IF(AND({Status}="", {Replacement Required}="Yes", IF(NOW()>WORKDAY({Date Created}, 2)), "true condition", "false condition")

Thanks for the response. I needed to put in an extra bracket and now have:

IF(AND({Status}="", {Replacement Required}=“Yes”, IF(NOW()>WORKDAY({Date Created}, 2))), “true condition”, “false condition”)

The strange thing is I get “false condition” returned in all cases. I have broken down all three components of the test and can see that there are rows that should return true. Any ideas?

In case my last response was confusing, I have made visible the columns actually referred to in the formula.

I think the IF() in your initial parameters was slightly misleading. You don’t need the IF around it for it to work. I think this should do the trick:

        {Replacement Required}="Yes",
        NOW() > WORKDAY({Date Created}, 2)
    "true condition",
    "false condition"

You might need to change the names of the fields in the formula to match your actual fields, as your screenshot shows different names.


Thanks Justin! That worked a treat.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.