Skip to main content
Solved

IF & AND statement on two fields, date and checkbox

  • March 16, 2021
  • 2 replies
  • 29 views
D

Hi

I have two fields that I am trying to use an IF AND statement on

One is a date field {Rollout Date} and one is a checkbox {BU Code Updated}

I want to write a statement that returns an “error” message when the date is before today’s date and the checkbox is {BU Code Updated} checkbox is unchecked - nothing needs to be returned if the date is after today and the checkbox is unchecked

Best answer by Raminder_Singh

This should work: IF(AND(IS_BEFORE({Rollout Date}, TODAY()), NOT({BU Code Updated})), ERROR("Your error here"))

    2 replies

    R
    Forum|alt.badge.img+3
    • Raminder_Singh
    • Participating Frequently
    • Answer
    • March 16, 2021

    This should work: IF(AND(IS_BEFORE({Rollout Date}, TODAY()), NOT({BU Code Updated})), ERROR("Your error here"))

    D
    • Douglas_Roberts
    • Author
    • Participating Frequently
    • March 16, 2021

    This should work: IF(AND(IS_BEFORE({Rollout Date}, TODAY()), NOT({BU Code Updated})), ERROR("Your error here"))


    Thanks. worked perfectly

    Terms & ConditionsAccessibility statement