Combining ISBLANK, IF & AND

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!