At Risk Function using date midpoint?

Sam N

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.

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!