Add planned start date to a Program report?

Question

Hello!  Is there a way to add the planned start date of a Project (or the first task in a projects start on date) to a Program Level report? Please let me know if you need more info! Thank you!

VicSellers · Accepted Answer

Yes!

1336200

I believe this is the template number. ^

Ah, so that looks like the Reference Number of the Template. So, to get the Template ID, navigate to the template itself and the ID is the number in the URL of that page. So, the text mode below, just swap out the ID for the template you have and it should work (but also should mention this assumes that the same template isn't used multiple times in the program).

displayname=Project Planned Start Dates
listdelimiter=<p>
listmethod=nested(projects).lists
textmode=true
type=iterate
valueexpression=IF({templateID}='ID',{plannedStartDate})
valueformat=HTML

listmethod=nested(projects).liststextmode=truetype=iteratevalueexpression=IF({templateID}='ID',{plannedStartDate})valueformat=HTML

VicSellers · Answer

Hi @lizpowell - You can use a collection text mode to pull in the project-level details to a program report. Here is more information on collections. This text mode is just the dates:displayname=Project Planned Start Dateslistdelimiter=

listmethod=nested(projects).liststextmode=truetype=iteratevalueexpression={plannedStartDate}valueformat=HTML This text mode includes the project names and dates:displayname=Project Planned Start Dateslistdelimiter=

listmethod=nested(projects).liststextmode=truetype=iteratevalueexpression=CONCAT({name}," ",{plannedStartDate})valueformat=HTML

Sign up

Login with SSO

Login to the community

Login with SSO