Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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
  #2  
Old 11-05-2015, 10:27 AM
ebilbrough ebilbrough is offline Task Name / date in a formula or custom column Windows 10 Task Name / date in a formula or custom column Office 2013
Novice
Task Name / date in a formula or custom column
 
Join Date: Nov 2015
Location: Austin, TX
Posts: 19
ebilbrough is on a distinguished road
Default

That's exactly what I needed. Many thanks Julie!
Reply With Quote
  #3  
Old 11-05-2015, 12:59 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

You're welcome and thanks for the feedback.
Reply With Quote
Reply



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 05:49 AM.


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