Adding a specific TASK Planned Start Date to a Project Report View | Community
Skip to main content
B
BrianHa3
Level 2
May 1, 2024
Solved

Adding a specific TASK Planned Start Date to a Project Report View

  • May 1, 2024
  • 1 reply
  • 1257 views

Hi Workfront Friends! I'm looking for some text mode assistance. We have a series of projects, all of which contain a task for "Initial Launch". When viewing a report of all of these projects, I would love to be able to have a column with the Planned Start Date of the "Initial Launch" task for each one of these projects. Any suggestions?

Best answer by VicSellers

Hi @brianha3 - This should work, but let me know if not!

 

displayname=Initial Launch Date listdelimiter=<div> listmethod=nested(tasks).lists textmode=true type=iterate valueexpression=IF(CONTAINS("Initial Launch",{name}),CONCAT({plannedStartDate})) valueformat=HTML

1 reply

VicSellers
Community Advisor
VicSellersCommunity AdvisorAccepted solution
Community Advisor
May 1, 2024

Hi @brianha3 - This should work, but let me know if not!

 

displayname=Initial Launch Date listdelimiter=<div> listmethod=nested(tasks).lists textmode=true type=iterate valueexpression=IF(CONTAINS("Initial Launch",{name}),CONCAT({plannedStartDate})) valueformat=HTML
    JessicaBCrum
    JessicaBCrum
    Level 2
    May 1, 2024

    I am actually trying to do something similar, but slightly different and wondering if you have any advice @vicsellers. I am trying to report on the duration between the actual completion date of one type of task (DE:Task Type = Copy Deliverable) in a project and the actual completion date of another task type (DE:Task Type = Deliverable) within a project. I have done something similar using a few calculated fields (as I need to group in to chart) I created to calculate the duration between the project actual start date and and the deliverable task actual completion date, but can't seem to figure out how to replicate this for two task type dates. Any help would be greatly appreciated!


    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity Advisor
    Community Advisor
    May 1, 2024

     

    Hi Jess,

     

    Calculating the duration between two Tasks' Actual Duration Dates is tricky, but I wrote up one technique you might find of use in this Going The Extra Milestone blog post.

     

    Regards,

    Doug

    Terms & ConditionsAccessibility statement

    Loading footer...