N
Naomi Nissen
I have been trying to get a view PWA to show if a project is late
based on the status of the subtasks; if any one task is late
(completed tasks, if they were late, don't count) then the project
will show up as late in PWA. The "status" column (late only) in
Project Pro is exactly what I'd like to show in PWA but as Dale has
answered here previously, there is no match in PWA. I have been
wrestling with formulas for weeks now. Forgive me if you've read and
answered my previous posts about this; I've been circling this problem
and can't figure it out. I have a column task-number that works
nicely task by task, and rolls up to the summary row in a project.
The formula is IIf([% Complete]<100 And Now()>[Finish],1,0).
Similarly, IIf(IIf([Finish]>Date(),100,0)+[% Complete]<100,1,0)
works. I tried importing these formulas to a project-number field
with the same graphical indicators but when I add this field in PWA
all the projects show green balls when they should be red, and the
summary task is red. I know I'm not great with formulas, and a lot of
people here seem to be able to flip them with ease, but I'd really
appreciate any help with details. I've read the stoplight paper over
and over again...
Thanks,
Naomi
based on the status of the subtasks; if any one task is late
(completed tasks, if they were late, don't count) then the project
will show up as late in PWA. The "status" column (late only) in
Project Pro is exactly what I'd like to show in PWA but as Dale has
answered here previously, there is no match in PWA. I have been
wrestling with formulas for weeks now. Forgive me if you've read and
answered my previous posts about this; I've been circling this problem
and can't figure it out. I have a column task-number that works
nicely task by task, and rolls up to the summary row in a project.
The formula is IIf([% Complete]<100 And Now()>[Finish],1,0).
Similarly, IIf(IIf([Finish]>Date(),100,0)+[% Complete]<100,1,0)
works. I tried importing these formulas to a project-number field
with the same graphical indicators but when I add this field in PWA
all the projects show green balls when they should be red, and the
summary task is red. I know I'm not great with formulas, and a lot of
people here seem to be able to flip them with ease, but I'd really
appreciate any help with details. I've read the stoplight paper over
and over again...
Thanks,
Naomi