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

  • 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.

    Regards,

    Marco de Oliveira

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!