Trying to combine AND and OR into one IF statement

Pamela Ivey

Hello,

I’m trying to combine an IF statement with AND and OR statements. The logic is to check if a date column is TODAY() and IF at least one of 10 columns is blank, then check a box.

I’ve tried multiple scenarios but can’t get it to work. The latest I have is:

=IF(OR(ISBLANK([Email]@row), ISBLANK([Street Address]@row), ISBLANK([City]@row), ISBLANK([State]@row), ISBLANK([Zip Code]@row), ISBLANK([Email Address]@row), ISBLANK([Telephone Number]@row), ISBLANK([Standard Hardware]@row), ISBLANK([Computer Hardware]@row), ISBLANK([Laptop Bag]@row),IF(AND([Reminder Calculated Date]@row = TODAY()), 1).

Any help would be greatly appreciated. Thanks.

Taylor Froese

You'll need to put the AND function at the front of the formula.

=IF(AND(OR(ISBLANK([Email]@row), ISBLANK([Street Address]@row), ISBLANK([City]@row), ISBLANK([State]@row), ISBLANK([Zip Code]@row), ISBLANK([Email Address]@row), ISBLANK([Telephone Number]@row), ISBLANK([Standard Hardware]@row), ISBLANK([Computer Hardware]@row), ISBLANK([Laptop Bag]@row)), [Reminder Calculated Date]@row = TODAY()), [True], [False])

Pamela Ivey

Thank you so much! It worked perfectly!

Taylor Froese

You'll need to put the AND function at the front of the formula.

=IF(AND(OR(ISBLANK([Email]@row), ISBLANK([Street Address]@row), ISBLANK([City]@row), ISBLANK([State]@row), ISBLANK([Zip Code]@row), ISBLANK([Email Address]@row), ISBLANK([Telephone Number]@row), ISBLANK([Standard Hardware]@row), ISBLANK([Computer Hardware]@row), ISBLANK([Laptop Bag]@row)), [Reminder Calculated Date]@row = TODAY()), [True], [False])

Pamela Ivey

Thank you so much! It worked perfectly!