Thanks Jan,
It did the trick!
Any suggestions for an online resource that provides the functions, etc. to allow me to write other VB solutions for MSP?
"Jan De Messemaeker" <jandemes at prom hyphen ade dot be> wrote in message Hi Glenn,
No need to seach, try this.
I suppose your condition (red, green, yellow) is in Number1 and that the highest condition of all predecessors has to be copied to the successor's Number2. You will probably be able to adapt this to your environment:
Sub FromPred()
dim Job as task
dim Pre as task
for each job in activeproject.tasks
if not job is nothing then
job.number2=0
for each pre in job.predecessortasks
if pre.number1>job.number2 then
job.number2=pre.number1
endif
next pre
endif
next job
end sub
Hope this helps
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"Glenn" <netmail@noSpam_thelemonranch.com> schreef in bericht Thanks Jan,
I was thinking that if I parsed the predecessor ID#s field, I could somehow determine the status of each predecessor task. Then, based on the predecessor's completion status, completion dates (planned and actual), and / or status of the task (red, green, yellow), I could change the status of the current task. But, based on your comment, I guess I can't use a formula to look at a field in another task... bummer.
Any suggestions on where I could find any VBA samples or tips on how to change a task's flag field, based on a predecessor's status as noted above?
Or, am I approaching this the wrong way?
Thanks for your help!
Glenn
"Jan De Messemaeker" <jandemes at prom hyphen ade dot be> wrote in message Hi Glenn,
When you will introduce conditions between fields of several taks you will need VBA.
Formulas are restricted to comparing fields within the task
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"Glenn" <netmail@noSpam_thelemonranch.com> schreef in bericht Perfect Gerard!
I was actually using a text field, initially, and wondered how to utilize the rollup feature. I didn't think about trying a number field, but since you mentioned it, it makes perfect sense!
I'm going to take another step... not only will I show red, green, yellow based on completion and date. I will use a number or text field, where I can use it to override the automated settings for tasks that have plenty of time to finish, but have issues that won't allow it to complete on time. This will then show a yellow flag until I discontinue the override.
An example of this would be where if a task is "Install router". Eventhough the date may be a 2 months out and the router can be shipped in 3 weeks and the indicator shows green, If I know the rack can't be installed in time to install the router, I want the ability to force a yellow flag indicator for the task "Install router". Now I need to figure-out how to automagically change the flag to yellow on the "Install router" task, if I force a yellow flag on the predecessor task "Install rack".
I love MS Project! It never ceases to amaze me with it's abilities!!
Glenn
Hello Glenn,
You don't say what kind of field you used to these Red, Yellow and Green symbols.
If you used a Number(x) field and if the Red color matches the greatest value, in the Customize Field dialog, for Summaries and groups, select Report : Maximum
Hope this helps, tell us if that work,
Gérard ducouret
"Glenn" <netmail@nospam_thelemonranch.com> a écrit dans le message de I've created a text field formula that allows me graphical indicators to show whether a task is on track.
How do I have the summary row show a specific indicator based on the subtasks below? Although I think I want it to show the worst indicator of the subtasks, I want the flexibility to change as necessary.
Example:
1 Analysis (summary row - how do I show RED, based on the below?)
2 Interview Client (subtask - done ontime, GREEN)
3 Create Analysis document (subtask - not done, due yesterday, RED)
4 Review with Resources (subtask - due tomorrow, YELLOW)
Thanks in advance for any assistance
Glenn
