Published on Planning Planet (http://www.planningplanet.com)

Home > Discussion Forum > Upcoming due tasks in Project

Upcoming due tasks in Project

By Renzo Zelaya
Created 1 Jun 2017 - 21:07
Submitted by Renzo Zelaya on Thu, 2017-06-01 21:07

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)

By logging in, inputting data or deciding to view any further of our pages you agree to be bound by our Forum Rules, our T&C's and also our Privacy Policy
© Planning Planet 2000-2024. Run by Project Controllers for Project Controllers.
Source URL: http://www.planningplanet.com/forums/microsoft-project/611177/upcoming-due-tasks-project

Links:
[1] http://www.planningplanet.com/forums/microsoft-project