Solved

MS Project 2002 Add Custom Field

Posted on 2010-11-24
2
819 Views
Last Modified: 2013-11-15
Hello,

I know relatively nothing about MS Project but have a user who needs some modification done to this file and has no other resources, figured since I know MS Excel fairly well I might be able to help.  They would like to create a custom field using a conditional formula based on other existing fields at task level.  The existing fields are the start/end date and percetage complete.

Here is what they essentially are looking for:  A new column to be added after the status column that will allow them to filter and see incomplete tasks.  This needs to be based on the following parameters:
1. If the task is completed, ignore the task
2. If the task is late, show regardless of date.
3.  If the task is within 2 weeks of scheduled completion, show the task.

Therefore, on the attached sample file, rows 3 & 4 would be ignored since they are already completed.  Rows 5-6 would show since they are late.  Rows 7-10 would show since they are within 2 weeks of todays date.  Rows 11-14 would not show since they are future tasks beyond 2 weeks of todays date.  I have a sample file but cannot get it to load in EE due to the file extension so I'll post an image instead.

Can someone please assist in putting something like this together?

Thanks!
MS-Project.jpg
0
Comment
Question by:Escanaba
2 Comments
 
LVL 4

Accepted Solution

by:
EFernandes earned 500 total points
ID: 34207032
If I understood correctly, this should help you: http://blogs.techrepublic.com.com/tech-manager/?p=3309 
0
 
LVL 1

Author Closing Comment

by:Escanaba
ID: 34230963
Thanks!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: x-men
Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
When we talk about DevOps toolchains, I sometimes wonder how many people really get what we’re talking about. I don’t know if it’s just semantics or tone or something else, but sometimes I think it just sounds like buzzword sausage. So it’s always …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now