ISBLANK Formula for Early, On-Time, Late Tasks

Ian Herzing

Hi there,

Thanks in advance for the help.

I would love to be able to have the "Completion" column show as blank if the "Target Release" cell is also blank.

Here's what I have written now:

Somehow I need to be using "ISBLANK" but I am not sure how to nest it.

Thanks so much,

Ian

Kelly Moore

Hey @Ian Herzing

Try this

=IF(ISDATE([Target Release]@row), IF([Target Release]@row>[End Date]@row, "Late", IF([Target Release]@row=[End Date]@row, "On Time", "Early")))

Will this work for you?

Kelly

Kelly Moore

Hey @Ian Herzing

Try this

=IF(ISDATE([Target Release]@row), IF([Target Release]@row>[End Date]@row, "Late", IF([Target Release]@row=[End Date]@row, "On Time", "Early")))

Will this work for you?

Kelly

Ian Herzing

@Kelly Moore - You're actually the BEST - this worked perfectly, tysm.

Kelly Moore

You're kind. I'm glad it worked for you

Kelly