Blank cells causing INVALID OPERATION error

Options

Hi -

I hope someone can tell me what I need to add to make this work. I have three columns: Due Date, Date Received, and Milestone Exceeded (Flag column). The goal is to have the flag turn red if 1)the due date has passed and the date received is blank, and when 2)the date received is past the due date. The formula I created for the flag column works for those two things. The problem comes when the Due Date is blank (Due date is generated by a formula when previous cell gets filled in). When Due Date is blank, I get #INVALID OPERATION error. I would like the flag to remain blank when the Due Date is blank. Here is what I have so far:

=IF(OR(AND(ISBLANK([Date Received]@row), TODAY() > [Due Date]@row), 1), IF([Date Received]@row > [Due Date]@row, 1))

What do I need to add to avoid the error message when the Due Date is blank?

Thanks for your assistance!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!