Trying to combine AND and OR into one IF statement

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.

Best Answers

  • Taylor Froese
    Taylor Froese ✭✭
    Answer ✓

    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
    Pamela Ivey ✭✭
    Answer ✓

    Thank you so much! It worked perfectly!

Answers

  • Taylor Froese
    Taylor Froese ✭✭
    Answer ✓

    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
    Pamela Ivey ✭✭
    Answer ✓

    Thank you so much! It worked perfectly!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!