Combining ISBLANK, IF & AND

John Kelly

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

Maddie Simonsen

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

Maddie Simonsen

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

John Kelly

Thanks Maddie,

That worked perfectly. I was pulling my hair our trying to get it to work.

Thanks,

John

Maddie Simonsen

Happy to help!