IF Statement with cell either blank or with any date

IF Statement with cell either blank or with any date

Hi everyone

Please can you assist me with correcting this formula? I have a column 1st queries received that is locked to dates only. This formula is for the health status column.

If the deadline is in the future, then the health status must be blank.

If the deadline is in the past, the received date is blank, and the responded checkbox is ticked then the health status must be blank.

If the deadline is in the past, and any received date is posted, and the responded checkbox is not ticked then the health status must be Red.

=IF(AND([1st Queries Deadline]@row < TODAY(365), [1st Queries Received]@row > "", [1st Queries Responded]@row = 0), "Red", "")

Regards,

Marco de Oliveira

Best Answer

Answers

Sign In or Register to comment.