Project Custom Field: don't work!!!! (project Level)
in [Project]
|
From: Vit on 7 May 2008 22:52 Hello, I'm trying to customize a field on project level… The field have to show if a project has been updated or not o the last 14 days… I’m using Project Server 2003, Project Professional 2003 and PWA 2003. Here you are the step that I have followed: 1) Opened Project Professional 2003 2) Opened Enterprise Global (Tool -> Enterprise Options -> Open Enterprise Global) 3) Opened Enterprise Fields (Tool -> Customise -> Enterprise Fields…) 4) Selected “Project” 5) Selected “Text” 6) Inserted the following formula: IIf(DateDiff("d",[Last Update], [Current Date])>=14,"Update Required","Current") The problem is that the Project Fields Seems not to be updated…. On the PWA view, for example, there is the following information: Project Test Last Modified: 30/04/2008 Last Published: 30/04/2008 Custom Field: Updated Required But today is the 8th of May, so it have to be “Current”!!! I have check also on the Project Information (in Project Professional, Project -> Project Information…), and unfortunately, the custom field value is “Updated Required”… What’s wrong?? Where can I check “Last Modified Date”, “Last Update Date” and “Last Published Date” in Project Professional?? Thank you so much to every body will be able to help me… Regards Vit
From: Rod Gill on 8 May 2008 00:35 Hi, Try: IIf(DateDiff("d",[Last Update],Date())>=14,"Update Required","Current") -- Rod Gill Microsoft MVP for Project Author of the only book on Project VBA, see: http://www.projectvbabook.com "Vit" <FiNaR76(a)gmail.com> wrote in message news:59360d98-b472-4e6b-937b-8d0d965b8537(a)l28g2000prd.googlegroups.com... Hello, I'm trying to customize a field on project level� The field have to show if a project has been updated or not o the last 14 days� I�m using Project Server 2003, Project Professional 2003 and PWA 2003. Here you are the step that I have followed: 1) Opened Project Professional 2003 2) Opened Enterprise Global (Tool -> Enterprise Options -> Open Enterprise Global) 3) Opened Enterprise Fields (Tool -> Customise -> Enterprise Fields�) 4) Selected �Project� 5) Selected �Text� 6) Inserted the following formula: IIf(DateDiff("d",[Last Update], [Current Date])>=14,"Update Required","Current") The problem is that the Project Fields Seems not to be updated�. On the PWA view, for example, there is the following information: Project Test Last Modified: 30/04/2008 Last Published: 30/04/2008 Custom Field: Updated Required But today is the 8th of May, so it have to be �Current�!!! I have check also on the Project Information (in Project Professional, Project -> Project Information�), and unfortunately, the custom field value is �Updated Required�� What�s wrong?? Where can I check �Last Modified Date�, �Last Update Date� and �Last Published Date� in Project Professional?? Thank you so much to every body will be able to help me� Regards Vit
From: Matthew Hodgson on 8 May 2008 02:53 Hello, I think the issue is that the calculation will only be performed when the plan is opened and republished (and hence you'll get a "Current" calculated) This is because formulas are calculated by Project - not on the Server. So you will never get this data to show through PWA in the manner you'd like. Instead of this method perhaps use "last published" field and sort / filter the PWA views to look for any plan not published in the last 14 days and invoke a business rule to tell everyone they must update their plans at least fortnightly (in your case). Hope that helps. Best of luck. Matthew "Rod Gill" <rodATproject-systemsDOTcoDOTnz> wrote in message news:e9SUDUMsIHA.4492(a)TK2MSFTNGP02.phx.gbl... > Hi, > > Try: > > IIf(DateDiff("d",[Last Update],Date())>=14,"Update Required","Current") > > -- > > Rod Gill > Microsoft MVP for Project > > Author of the only book on Project VBA, see: > http://www.projectvbabook.com > > > > "Vit" <FiNaR76(a)gmail.com> wrote in message > news:59360d98-b472-4e6b-937b-8d0d965b8537(a)l28g2000prd.googlegroups.com... > Hello, > > I'm trying to customize a field on project level� > > The field have to show if a project has been updated or not o the last > 14 days� > > I�m using Project Server 2003, Project Professional 2003 and PWA 2003. > > Here you are the step that I have followed: > > 1) Opened Project Professional 2003 > 2) Opened Enterprise Global (Tool -> Enterprise Options -> Open > Enterprise Global) > 3) Opened Enterprise Fields (Tool -> Customise -> Enterprise Fields�) > 4) Selected �Project� > 5) Selected �Text� > 6) Inserted the following formula: IIf(DateDiff("d",[Last Update], > [Current Date])>=14,"Update Required","Current") > > The problem is that the Project Fields Seems not to be updated�. > > On the PWA view, for example, there is the following information: > > Project Test > Last Modified: 30/04/2008 > Last Published: 30/04/2008 > Custom Field: Updated Required > > But today is the 8th of May, so it have to be �Current�!!! > > I have check also on the Project Information (in Project Professional, > Project -> Project Information�), and unfortunately, the custom field > value is �Updated Required�� > > What�s wrong?? > > Where can I check �Last Modified Date�, �Last Update Date� and �Last > Published Date� in Project Professional?? > > Thank you so much to every body will be able to help me� > > Regards > > Vit
From: Mike Glen on 8 May 2008 10:07 Hi Vit, Next time, please post on the server newsgroup. Please see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful Project information can be seen at this web address: http://project.mvps.org/faqs.htm Mike Glen Project MVP Vit wrote: > Hello, > > I'm trying to customize a field on project level� > > The field have to show if a project has been updated or not o the last > 14 days� > > I�m using Project Server 2003, Project Professional 2003 and PWA 2003. > > Here you are the step that I have followed: > > 1) Opened Project Professional 2003 > 2) Opened Enterprise Global (Tool -> Enterprise Options -> Open > Enterprise Global) > 3) Opened Enterprise Fields (Tool -> Customise -> Enterprise Fields�) > 4) Selected �Project� > 5) Selected �Text� > 6) Inserted the following formula: IIf(DateDiff("d",[Last Update], > [Current Date])>=14,"Update Required","Current") > > The problem is that the Project Fields Seems not to be updated�. > > On the PWA view, for example, there is the following information: > > Project Test > Last Modified: 30/04/2008 > Last Published: 30/04/2008 > Custom Field: Updated Required > > But today is the 8th of May, so it have to be �Current�!!! > > I have check also on the Project Information (in Project Professional, > Project -> Project Information�), and unfortunately, the custom field > value is �Updated Required�� > > What�s wrong?? > > Where can I check �Last Modified Date�, �Last Update Date� and �Last > Published Date� in Project Professional?? > > Thank you so much to every body will be able to help me� > > Regards > > Vit
|
Pages: 1 Prev: make a column stay Next: showing a milestone in a summary bar |