Combining ISBLANK, IF & AND

Hi All,
I would appreciate your help with trying to set up a formula. I am trying to activate the at risk flag when the 'Date information required' cell is in the past. The side note to this is that I only want it flagged if the 'Date information received' cell is blank and that the flag is not highlighted when all date cells are blank.
I have implemented the formula below which works to a degree. The fault with it is, it is flagging regardless of whether the 'Date information required date' is in the future or past.
=IF(ISBLANK([Date Information Received]@row), NOT(ISBLANK([Date information Required]@row)), [Date information Required]@row < TODAY())
Thanks in advance,
John
Best Answer
-
Hi John,
This should work:
=IF(ISBLANK([Date Information Required]@row), 0, IF(AND([Date Information Required]@row < TODAY(), ISBLANK([Date Information Received]@row)), 1))
Maddie
Answers
-
Hi John,
This should work:
=IF(ISBLANK([Date Information Required]@row), 0, IF(AND([Date Information Required]@row < TODAY(), ISBLANK([Date Information Received]@row)), 1))
Maddie
-
Thanks Maddie,
That worked perfectly. I was pulling my hair our trying to get it to work.
Thanks,
John
-
Happy to help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!