At Risk Function using date midpoint?

Hi everyone,

I'm hoping someone can help me here - because I'm completely stuck. I'm working on building an equation that flags something as "at risk" if the following conditions are met

Project Status is "In Progress"
The halfway point between the Project Start Date and the Project End Date has passed.
Percent Complete is not 100%

Ideally, the "At risk" column is blank if the Project Status is "Not Started" or "On Hold" and says "No" if the project has not met the above conditions, but is in "progress" or "completed"

Thank you all. I'm pretty sure I can figure out everything except the halfway point request.

Find more posts tagged with

Formulas

Accepted answers

All comments

Kelly P.

@Sam N

You could try this:

=IF(AND([Project Status]@row = "In Progress", [Percent Complete]@row < 1, TODAY() >= ([Project Start Date]@row + ([Project End Date]@row - [Project Start Date]@row) / 2)), 1, 0)

Hope this helps!

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.