Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 11-04-2015, 02:48 PM
JulieS JulieS is offline Task Name / date in a formula or custom column Windows 7 64bit Task Name / date in a formula or custom column Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Task Name / date in a formula or custom column Embedded Excel in Powerpoint - custom animation, display column by column andytheanimal PowerPoint 2 01-20-2015 06:30 AM
Task Name / date in a formula or custom column 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
Task Name / date in a formula or custom column Automatically enter date into a column and make that column read only Mr Davo Excel 1 10-29-2012 01:07 AM
Task Name / date in a formula or custom column Custom field formula not working at summary task level abw1987 Project 3 10-05-2011 07:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:27 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft