IF Statement with cell either blank or with any date

Marco de Oliveira

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", "")

Ramzi K

Hi @Marco de Oliveira,

You cannot use a > "" operator on a date field.

Instead, try [1st Queries Received]@row <> "" or better yet NOT(ISBLANK([1st Queries Received]@row))

I hope this helps.

Cheers,

Ramzi

Ramzi K

Hi @Marco de Oliveira,

You cannot use a > "" operator on a date field.

Instead, try [1st Queries Received]@row <> "" or better yet NOT(ISBLANK([1st Queries Received]@row))

I hope this helps.

Cheers,

Ramzi

Marco de Oliveira

Amazing, thanks. As a matter of interest, I had tried the <> "" one before and it did not work, but the NOT(ISBLANK() works perfectly.

Thanks so much.