Red Flag for overdue tasks

Hi,

I have used the formula =IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1) in the flag column to turn the flag red when the end date is passed and completion is less than 100% which is great.

BUT....

It now red flags every row that doesn't have a date in yes which is an issue as we are using a project management template which will house all backlog items etc that may not yet have dates allocated to them. Is there a way to stop this happening and only run the flag when there is a end date and % complete in the row but not when it is blank?

Thankyou!!

Find more posts tagged with

Formulas

functionality

Conditional Formatting

Project Management

Accepted answers

Jason Tarpinian

Just wrap everything you have in another IF blank statement.

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

The symbol for blank is two adjacent quotation marks.

All comments

Jason Tarpinian

Just wrap everything you have in another IF blank statement.

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

The symbol for blank is two adjacent quotation marks.

Ruth Potts

That is perfect! Thankyou very much

tylermh

@Jason Tarpinian How about an IF/COUNTIF formula for an automatic flag when a contact's name appears in the Contact column for a 3rd time? (incident tracking report)

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.