Is there a way to pull the baseline start & end dates from a project sheet?

Freymish

I am creating a project status dashboard that will encompass all of our projects. It's simple enough to link each line to a project but the thing I want to be able to grab is the baseline start and end dates from the project. Short of scanning a column and finding the lowest and highest numbers, is there a way to access this value programmatically?

Freymish

I ended up just doing a scan of a column and finding the lowest number to use as the start date.

David Tutwiler

If you look at the Project Plan in Gannt view, you should see an option on the far right of the toolbar called Baselines. This would allow you to capture the baseline dates so that as the sheet changes, the baseline information can tell you the variance between the original baseline and current projections.

Is that what you were looking for?

Freymish

Thanks. I can "see" the baseline there of course. What I'm interested in is pulling it as part of a function. At the moment I am looking at the dates for tassks and picking the lowest date as the start date. i.e. =MIN({ProjectNme StartDates})

It works but I was curious if there was a better way as it's conceivable that the Start date and the date of the first task might not always coincide.

Freymish

I ended up just doing a scan of a column and finding the lowest number to use as the start date.