Skip to content
ProjectControls.com
Microsoft Project

Upcoming due tasks in Project

In the Open Standard
Renzo ZelayaMember for 9 years 4 months
Created
1
3
0

I'm trying to set up a flag or filter in Project to capture upcoming tasks that are not yet done. 

This is the IIf statement I'm using for a custom field. Project accepts the syntax, but returns all fields as a 0. What am I doing wrong? The statement is meant to flag all tasks that are not done and a finish date within the next 7 days.

IIf(([% Complete]<100) AND ([Actual Finish]<ProjDateAdd([Current Date],"+7d")), 1, 0)

Save Follow Follow forum Report
Reply New topic

1 reply

Oldest first
  1. 0
    Tom Boyle ·
    #1

    Renzo,The two expressions on

    Renzo,

    The two expressions on either side of your AND operator are mutually exclusive - a task cannot be incomplete AND still have an actual finish date - so the condition always evaluates to FALSE.  Why not use [Finish] instead of [Actual Finish]?

    Good luck, tom 

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?