ISBLANK Formula Error

Options

I've been working on variations of this formula for an hour and can't get it right. I've been close but it hasn't returned what I was expecting.

I have 3 columns - Actual Completion Date, Status and Due Date. If the Due Date < Today and Status is not Closed then I want it to return 'Past Due'. The problem is that some users are entering the Actual Completion Date and not moving the Status to 'Closed'. If that is the case, then I don't want it to return anything.

My other issue is that when I had blank rows, the cell was returning an INVALID OPERATION error.

=IFERROR(IF(ISBLANK([Actual Completion Date]@row)), (IF(AND([Status]@row <> "Closed", [Due Date], < TODAY(), "Past Due")), "")

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!