Skip to main content

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

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

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


Thanks. worked perfectly

Reply


Terms & Conditions