IF Formulas including Blanks and AND / OR

Cheryl Collins

Hi

I'm looking for a formula that will show me whether a deadline has been met.

My Deadline Met formula is currently only taking into account the Agreed Deadline Date and the Date Completed =IF([Date Complete]@row <= [Agreed Deadline]@row, "Yes", "No")

However, what I really need it to do is also check if a). There is a date in the Renegotiated Date and if there is, is this date <= Date Completed.

The use cases are:

As a job completer

I want to select Complete once I have completed a job allocated to me

So that the date completed can be recorded

As a supervisor

I want to be able to see whether a deadline was met, whether it was an originally agreed deadline or re-negotiated date

So that I can track how many jobs are being completed on time

Hope that helps

TIA

Cheryl

Christian G.

How about that?

=IF([Date Complete]@row <= IF(isblank([Renegociated date]@row),[Agreed Deadline]@row,[Renegociated date]@row), "Yes", "No")

Christian G.

How about that?

=IF([Date Complete]@row <= IF(isblank([Renegociated date]@row),[Agreed Deadline]@row,[Renegociated date]@row), "Yes", "No")

Cheryl Collins

Hi @Christian G.

That has worked like a charm!

Thanks so much

Cheryl