At risk flag formula help (please!)

Hi there,

I am attempting to enter a formula in a flag column to automatically show at risk (red) when tasks are overdue and not 100% complete AND when due date is within 7 days and the %complete column is not 100%.

Attached is a screenshot of what I have taken a stab at, I am not amazing at multiple condition formulas so this is likely a bit of a mess. Formula used =IF(AND(Finish@row >= TODAY(-7), [% Complete]@row < 1), IF(AND(Finish@row < TODAY(), [% Complete]@row < 1), 1, 0))

I am in Australia if that helps with any formatting, please can someone show me how to construct this formula so it functions?

Thanks,

Elise

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try this...

=IF(AND([% Complete]@row < 1, Finish@row <= TODAY(7)), 1)

All comments

Paul Newcome

Try this...

=IF(AND([% Complete]@row < 1, Finish@row <= TODAY(7)), 1)

EliseB

Thanks Paul, that is great. Appreciate it!

Elise

Paul Newcome

Happy to help. 👍️

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.