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?