Hi,

I'm managing several project schedules all of which have the milestone task GoLive. In each project file I would like to capture the date for the GoLive task into a custom date column I've created. Is there a way to do this via a formula or other method?

Many thanks for your help.

Usually you cannot extract data from a single task through a formula. Is the "GoLive" date a task finish or start date? Is it the finish date of the Project or does the project have tasks past "go Live"?

What do you want to do with that date? Custom columns normally have data for each task.

Thank you Julie for the reply.

The GoLive date is a milestone. There are tasks that occur after this milestone. Ultimately what I'm trying to achieve is having the GoLive task date appear in my SharePoint PWA Project Center view.

My SharePoint PWA view contains the Summary Level for each of my projects. I was hoping to capture this task date into a custom column which can be added to my view.

Let me know if that explains it better.

Many thanks.

Also, the GoLive milestone task does have a predecessor.

A custom field is going to show a value for each task. With a bit of fiddly work - you may be able to get it to work. For an example - set the Marked field for the "Go Live" date to "yes". Then in a date field:

IIf([Marked]=Yes,[Finish],ProjDateValue("NA"))

The formula should now show the date for the marked task.

Set the Calculation for group or summary rows to Maximum. Now that date appears at the Project summary task line.

Sorry - I can't suggest how to add the value to PWA. But yo should now have the DateX Project summary task value = Go live date.

That's exactly what I needed. Many thanks Julie!

You're welcome and thanks for the feedback.