Red Flag for Past Due

Hi!

Hoping someone can help. I'd like a red flag in a column for a task that is overdue reading a status column. When status is complete, it no longer needs to flag. I can't get this to work! At the moment I'm using:

=IF([Due Date Q1]@row = "", 0, IF(OR([% Complete]@row < 1, [Due Date Q1]@row < TODAY()), 1, 0))

I need the %Compelte column ref taken out but I can't get this to work.

At the moment, it's flagging past due but not stopping the flag if it's marked as complete.

Thanks!

Find more posts tagged with

Accepted answers

All comments

DanniB

=IF(OR(AND([Due Date Q1]@row < TODAY(), [Owner Status]@row = "Not Started"), AND([Due Date Q1]@row < TODAY(), [Owner Status]@row = "In Progress"), IF(AND([Due Date Q1]@row < TODAY(), [Owner Status]@row = "Comments Provided"), 1, 0)))

Had a go.....it was working great until I added that I needed a flag for the Owner Status column to read 'Comments Provided' as a flag too....any ideas?

Paul Newcome

Try this:

=IF(AND([Due Date Q1]@row< TODAY(), OR([Owner Status]@row = "Not Started", [Owner Status]@row = "In Progress", [Owner Status]@row = "Comments Provided")), 1)

Emily Zeiger

You didn't finish the first IF statement and you were missing a ) right before that. Alternatively, if they all result in the same flag if true, you could get rid of the second IF - see the second formula. Hopefully one of these helps.

=IF(OR(AND([Due Date Q1]@row < TODAY(), [Owner Status]@row = "Not Started"), AND([Due Date Q1]@row < TODAY(), [Owner Status]@row = "In Progress")), INSERT WHAT HAPPENS IF TRUE HERE, IF(AND([Due Date Q1]@row < TODAY(), [Owner Status]@row = "Comments Provided"), 1, 0)))

=IF(OR(AND([Due Date Q1]@row < TODAY(), [Owner Status]@row = "Not Started"), AND([Due Date Q1]@row < TODAY(), [Owner Status]@row = "In Progress"), AND([Due Date Q1]@row < TODAY(), [Owner Status]@row = "Comments Provided")), 1, 0)

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.