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
-
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])
-
Thank you so much! It worked perfectly!
Answers
-
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])
-
Thank you so much! It worked perfectly!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!