How to display count of baselines in project online for specific project?

%3CLINGO-SUB%20id%3D%22lingo-sub-2180948%22%20slang%3D%22en-US%22%3EHow%20to%20display%20count%20of%20baselines%20in%20project%20online%20for%20specific%20project%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2180948%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EA%20project%20have%205%20baselines.%20Another%20project%20have%204%20baselines...etc.%20Then%20how%20to%20display%20the%20baseline%20count%20for%20specific%20project%20by%20using%20custom%20filed.%20Any%20one%20have%20idea%20about%20the%20custom%20formula%3F%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EAnil.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2181872%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20display%20count%20of%20baselines%20in%20project%20online%20for%20specific%20project%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2181872%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F983519%22%20target%3D%22_blank%22%3E%40Anil_kumar%3C%2FA%3E%2C%3C%2FP%3E%3CP%3EWell%20it%20might%20be%20possible%20with%20a%20very%20complex%20custom%20field%20formula%20but%20it%20would%20be%20much%20easier%20with%20VBA.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20say%20very%20complex%20custom%20field%20formula%20because%20it%20would%20have%20to%20utilize%20multiple%20tests%20to%20analyze%20every%20combination%20of%20the%2011%20Baselines%20along%20with%20a%20counter.%20If%20the%20baselines%20are%20always%20in%20sequence%20(i.e.%20Baseline%2C%20Baseline1%2C%20Baseline2%2C%20etc.%20as%20opposed%20to%2C%20Baseline%2C%20Baseline2%2C%20Baseline5%2C%20etc.)%20the%20formula%20would%20be%20a%20bit%20less%20complex%20but%20nonetheless%20still%20large.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps%3C%2FP%3E%3CP%3EJohn%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi all,

A project have 5 baselines. Another project have 4 baselines...etc. Then how to display the baseline count for specific project by using custom filed. Any one have idea about the custom formula?

Regards,

Anil.

2 Replies

@Anil_kumar,

Well it might be possible with a very complex custom field formula but it would be much easier with VBA.

 

I say very complex custom field formula because it would have to utilize multiple tests to analyze every combination of the 11 Baselines along with a counter. If the baselines are always in sequence (i.e. Baseline, Baseline1, Baseline2, etc. as opposed to, Baseline, Baseline2, Baseline5, etc.) the formula would be a bit less complex but nonetheless still large. So, if the baselines are in sequence, this formula in a custom Number field will do it, at least up through Baseline5. It will be on a task by task basis but you can rollup the maximum to summary lines which will include the Project Summary Task.

Number1=IIf([Baseline5 Start]<50000,6,IIf([Baseline4 Start]<50000,5,IIf([Baseline3 Start]<50000,4,IIf([Baseline2 Start]<50000,3,IIf([Baseline1 Start]<50000,2,IIf([Baseline Start]<50000,1,0))))))

 

Hope this helps

 

Oops, I didn't notice that you are using Project Online at first. I developed the formula for use with the desktop version of Project, I do not know if it will work with Project Online.

John

Hi @John-project ,

Thank u for your inputs......

Yes I am using project online. So, I had searched some forums and I got this formula to get the count of baselines.

This is the formula which I have used in project online custom filed 

IIf([Baseline10 Finish] <> ProjDateValue("NA"), "11", IIf([Baseline9 Finish] <> ProjDateValue("NA"), "10", IIf([Baseline8 Finish] <> ProjDateValue("NA"), "9", IIf([Baseline7 Finish] <> ProjDateValue("NA"), "8", IIf([Baseline6 Finish] <> ProjDateValue("NA"), "7", IIf([Baseline5 Finish] <> ProjDateValue("NA"), "6", IIf([Baseline4 Finish] <> ProjDateValue("NA"), "5", IIf([Baseline3 Finish] <> ProjDateValue("NA"), "4", IIf([Baseline2 Finish] <> ProjDateValue("NA"), "3", IIf([Baseline1 Finish] <> ProjDateValue("NA"), "2", IIf([Baseline Finish] <> ProjDateValue("NA"), "1", IIf(IsNull([Baseline Finish]), "0", "No Value"))))))))))))