Report to track Project Planned Completion Date Changes | Community
Skip to main content
A
Anonymous
February 9, 2018
Question

Report to track Project Planned Completion Date Changes

  • February 9, 2018
  • 11 replies
  • 1780 views
Good Afternoon...wondering if anyone has any ideas here. We are trying to monitor how often we change a projects "Planned Completion Date". Ideally, we would like to force people to enter a reason as to why they do this and make it mandatory but...that is separate. Is there a way to pull out in a report when someone makes an update to this field? Any help here would be greatly appreciated Brett Robison Cengage
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

11 replies

Show previous replies
Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
March 2, 2018
Hi Vic, As I just shared in this (somewhat tenuously) "https://community.workfront.com/discussions/community-home/digestviewer/viewthread?MessageKey=d49a5872-2ecd-4d93-8cb0-34f47fa22f9a&CommunityKey=aaafaff0-5e4e-4e38-8903-f1f990935567&tab=digestviewer&SuccessMsg=Thank+you+for+submitting+your+message.">related thread , another simple solution to this Planned Completion Date challenge would be to add a date calculated parameter to a custom form behind every Project of Interest called Original Planned Completion Date, with this formula: IF(Status='CUR',IF(ISBLANK(Original Planned Completion Date),Planned Completion Date,Original Planned Completion Date),Original Planned Completion Date) What this subtle gem does is to capture (forever) whatever the Planned Completion Date on every existing Current Project to which its custom form is already attached (e.g. up to "right now", in my client's case), and whatever the initial Planned Completion Date was when the Project was first set to Current on any Project to which the form is attached (e.g. from the Template, "going forward"). With that data in hand, you can then create a Project report that shows any Project whose Original Planned Completion Date is different from its Planned Completion Date. And (what the heck) even add some Project Level calculated parameters to show how many days different, what percentage of the whole timeline, etc. Geeky, but elegant. I like it on both counts. Thanks to Bonnie for helping me noodle it out! Regards, Doug P.S. the proper syntax is "IF" not "IIF" (whoops, my VBA dark roots are showing), and to get this formula to work, you'll need to add the parameter to the form with no formula, save (so Workfront "knows" that parameter exists), THEN add the formula (since it refers to that parameter) and save and close P.P.S. for existing Projects, remember to also Recalculate Custom Parameters to inject the initial values Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads
Terms & ConditionsAccessibility statement

Loading footer...