Need Help With a Custom Equation/Indicator MS Project 2007

J

Jonathon

I am having issues writing a custom equation in MS Project 2007 that
can
put an indicator next to any task that is due from the current date to
+14 days forward. Does anyone have any experience with this?

Thanks In Advance,
Jonathon
 
J

Jack Dahlgren

should be pretty simple with an iif statement

This for example shows some text for any uncomplete tasks due within the
next 14 days. It also captures any which were overdue but you can modify
that by adding another condition

IIf([% Complete]<100,IIf([Finish]<([Current Date]+14),"This is due within 14
days",""),"")

-Jack Dahlgren
http://zo-d.com/blog
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project Tasks Due 2
MS Project Overwrites Max. Resource hrs 0
MS Project: Issues with Custom Equations 1
Modify the gantt chart view in project center (WPA) (MS Project 2010) 0
Changing Baseline dates due to snow days 0
MS Project 2016 - all tasks not showing in Calendar View 0
Zeroing Out Resources Changes Start Date/Time 0
Project cannot recognize this file format in MS Project 2007 0

Top