Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

IF & AND statement on two fields, date and checkbox

Solved
Jump to Solution
294 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Solution

Accepted Solutions

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

See Solution in Thread

2 Replies 2

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

Thanks. worked perfectly