Project Custom Fields with Formulas.

[Ignbell]

HI,
I made a custom field on a proyect with a simple Project Formula that
shows me with a circle of diferent colors the state of my project, works
perrfectly on a project in PP2007 but when i added it onto a view in PWA (EX:
Summary) the boxes where de cicles should be are blank, (even if i configure
the field only to show Data).

My question is how do i create a Custom Field for a PWA Viiew in Project
Center to show users that the poject is late, Not so late and up to date?
My formula is:
Switch([% Concluída]=100,"1",[% Concluída]>=50,"2",[% Concluída]<50,"3")
% Concluída means % complete.
Very simple and works fine on my projects in Project Professional
I`d Appreciate any help.
Nacio.

 

[Marc Soester [MVP]]

Hi Ingbell,

Generally if it works in MS Project Server it should work for you too. Have
you republised the project after you have changed the Project Center view?
That should resolve your issue
Hope this helps

 

[Ignbell]

Marc,
After i two project fields in my project and on my view, the first one
has the Formula
First Formula:
IIf(INT([Início]-date())>=5,"A
Tiempo",IIf(INT([Conclusão]-date())>5,Switch([% Concluída]<=100,"A
Tiempo"),IIf(INT([Conclusão])-date()>0 And
INT([Conclusão]-date())<=5,Switch([% Concluída]<=50,"Cercano al Limite",[%
Concluída]>50,"A Tiempo"),IIf(INT([Conclusão]-date())=0,Switch([%
Concluída]=0,"Atrasado",[% Concluída]>50,"Cercano al Limite",[%
Concluída]=100,"A Tiempo "),Switch([% Concluída]=100,"A Tiempo",[%
Concluída]>25 And [% Concluída]<100,"Cercano al Limite",[%
Concluída]<=25,"Atrasado")))))

The second Formula is my short Formula:
Switch([% Concluída]=100,"1",[% Concluída]>=50,"2",[% Concluída]<50,"3")

Both formulas work well in Project Professional and they give me the data i
want. after i re-published the project and entering into Project Center in
PWA i can only see the results from the first formula while the field where
the results from the second formula is empty. Republished again, change the
values in Project Professional, still can`t make it work in PWA. Is my
formula well? i got no more ideas...

Thanks a lot,
Nacio.

Hi Ingbell,

Generally if it works in MS Project Server it should work for you too. Have
you republised the project after you have changed the Project Center view?
That should resolve your issue
Hope this helps
--
Marc Soester [MVP]
State Manager: EPM
http://marcsoester.blogspot.com

HI,
I made a custom field on a proyect with a simple Project Formula that
shows me with a circle of diferent colors the state of my project, works
perrfectly on a project in PP2007 but when i added it onto a view in PWA (EX:
Summary) the boxes where de cicles should be are blank, (even if i configure
the field only to show Data).

My question is how do i create a Custom Field for a PWA Viiew in Project
Center to show users that the poject is late, Not so late and up to date?
My formula is:
Switch([% Concluída]=100,"1",[% Concluída]>=50,"2",[% Concluída]<50,"3")
% Concluída means % complete.
Very simple and works fine on my projects in Project Professional
I`d Appreciate any help.
Nacio.

 

[Ignbell]

Marc! it works now, i republieshed it again and again, now i can see the
results of both formulas.
Thanks man! i own you 3 already.
Good luck!
Nacio.

Hi Ingbell,

Generally if it works in MS Project Server it should work for you too. Have
you republised the project after you have changed the Project Center view?
That should resolve your issue
Hope this helps
--
Marc Soester [MVP]
State Manager: EPM
http://marcsoester.blogspot.com

HI,
I made a custom field on a proyect with a simple Project Formula that
shows me with a circle of diferent colors the state of my project, works
perrfectly on a project in PP2007 but when i added it onto a view in PWA (EX:
Summary) the boxes where de cicles should be are blank, (even if i configure
the field only to show Data).

My question is how do i create a Custom Field for a PWA Viiew in Project
Center to show users that the poject is late, Not so late and up to date?
My formula is:
Switch([% Concluída]=100,"1",[% Concluída]>=50,"2",[% Concluída]<50,"3")
% Concluída means % complete.
Very simple and works fine on my projects in Project Professional
I`d Appreciate any help.
Nacio.