#1
|
|||
|
|||
Task Name / date in a formula or custom column
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. Last edited by ebilbrough; 11-04-2015 at 12:20 PM. Reason: Clarity |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
Also, the GoLive milestone task does have a predecessor.
|
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
That's exactly what I needed. Many thanks Julie!
|
#7
|
|||
|
|||
You're welcome and thanks for the feedback.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Embedded Excel in Powerpoint - custom animation, display column by column | andytheanimal | PowerPoint | 2 | 01-20-2015 06:30 AM |
MS Project to detect task level changes and record a date modified in custom field | RJTMEYER | Project | 3 | 08-22-2014 07:38 AM |
How to make a task adjust its end date depending on another task? (Newbie) | ravl13 | Project | 3 | 07-27-2014 06:10 PM |
Automatically enter date into a column and make that column read only | Mr Davo | Excel | 1 | 10-29-2012 01:07 AM |
Custom field formula not working at summary task level | abw1987 | Project | 3 | 10-05-2011 07:17 AM |