Skip to main content
Solved

Conditional IF with Date Check

  • July 3, 2020
  • 5 replies
  • 30 views
D

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.

Best answer by Justin_Barrett

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.

    5 replies

    Kamille_Parks11
    Forum|alt.badge.img+27

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

    D
    • Dominic_Rannie
    • Author
    • Known Participant
    • July 3, 2020

    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?

    D
    • Dominic_Rannie
    • Author
    • Known Participant
    • July 3, 2020

    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.

    Justin_Barrett
    Forum|alt.badge.img+21

    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.

    D
    Kamille_Parks11
    D
    • Dominic_Rannie
    • Author
    • Known Participant
    • July 4, 2020

    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.


    Thanks Justin! That worked a treat.

    Terms & ConditionsAccessibility statement