IF Formulas including Blanks and AND / OR

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

Find more posts tagged with

Formulas

Accepted answers

Christian G.

How about that?

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

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.