Need to add ISBLANK to a formula

Options

Good morning,

To determine the status of a row, I have the following formula (in the Status) column:

=IF(Complete1 = "Yes", "COMPLETED", IF(Complete1 = "Cancelled", "CANCELLED", (IF(TODAY() >= [Due Date]1, "PAST DUE", IF(TODAY(1) = [Due Date]1, "Due Tomorrow", "In Progress")))))

I need to add to this formula to leave the cells in the status column blank if the 'Due Date' field is blank. I've tried several variations of the following, but get an error each time.

=IF(Complete1 = "Yes", "COMPLETED", IF(Complete1 = "Cancelled", "CANCELLED", (IF(TODAY() >= [Due Date]1, "PAST DUE", IF(TODAY(1) = [Due Date]1, "Due Tomorrow", "In Progress", IF(ISBLANK([Due Date]1), " "))))))


What am I missing?


Thank you!

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!