Conditional IF with Date Check

Hi,

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:

IF(
    AND(
        {Status}="",
        {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.

2 Likes

Thanks Justin! That worked a treat.

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