Need Help with Approaching Due Date Formula

I have an Approaching Due Date column with the Star checkbox and I want to create a formula that will show the Star if today is between 7 working days in advance of the End Date and the End Date, and the Status is NOT Complete. I also have a column for Past Due with a Red Flag checkbox. I want the Approaching Due Date formula to exclude any tasks that are already marked as Past Due.

Currently, I have this formula in place (which is close to what I'm trying to do, but doesn't have the exclusion of Past Due line items) -

=IF(AND([End Date]@row <= TODAY(7), NOT(Status@row = "Complete")), 1, 0)

How can I write this to achieve the outcome described above?

Thanks!

Marcy

Find more posts tagged with

Formulas

Project Management

Accepted answers

Rochelle from Agilize

Hi Marcy! You're missing a few arguments in your formula. Give this one a shot:

=IF(AND([End Date]@row <= TODAY(7), [End Date]@row >= TODAY(), [Past Due Flag]@row = 0, NOT(Status@row = "Complete")), 1, 0)

Stay Agile,

agilizeconsulting.com

All comments

Rochelle from Agilize

Hi Marcy! You're missing a few arguments in your formula. Give this one a shot:

=IF(AND([End Date]@row <= TODAY(7), [End Date]@row >= TODAY(), [Past Due Flag]@row = 0, NOT(Status@row = "Complete")), 1, 0)

Stay Agile,

agilizeconsulting.com

Marcy Burkett

Hi Rochelle! Thank you SO much!! With one small edit, this worked like a charm. So appreciate your help. 😀

=IF(AND([End Date]@row <= TODAY(7), [End Date]@row >= TODAY(), [Past Due]@row = 0, NOT(Status@row = "Complete")), 1, 0)

Rochelle from Agilize

Good deal!! I'm glad it worked out!

Stay Agile,

agilizeconsulting.com

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.