Nesting ISBLANK within IF(AND) Statements

Options

Hello,

I have successfully established a formula link between two date columns (Start & Finish) and my 3 status trackers (Completed, In Progress, Not Started). The formula I have used successfully is:

=IF(AND(Start@row > TODAY(), Finish@row > TODAY()), "Not Started", IF(AND(Start@row < TODAY(), Finish@row > TODAY()), "In Progress", IF(AND(Start@row < TODAY(), Finish@row < TODAY()), "Completed")))

Now, however, any columns with blank Start / Finish dates are defaulting to "Completed". I would rather have them default as blank.

I attempted to nest ISBLANK in there as follows:

=IF(AND(Start@row > TODAY(), Finish@row > TODAY()), "Not Started", IF(AND(Start@row < TODAY(), Finish@row > TODAY()), "In Progress", IF(AND(Start@row < TODAY(), Finish@row < TODAY()), "Completed"), IF(ISBLANK(Start@Row), ""))

But that's throwing the your syntax isn't quite right error.

Any recommendations? Thanks all!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!