Reporting question - Project collection report where column is tasks that can start within the project

[Jcosta16]

I used to have a formula for a project collection report where the column would be tasks that can start within that project but I can no longer find it. Anyone have any ideas?

Additionally, would love if anyone has any ideas on how we could pull most recently completed and upcoming milestone(s) within the project? The milestone object reporting is too limited and I'd love to see this in a collections report somehow.

[GrahamJarrett · Accepted solution]

link.linkproperty.0.name=ID
link.linkproperty.0.valuefield=ID
link.linkproperty.0.valueformat=val
link.lookup=link.view
link.value=val(objCode)
listdelimiter=<br>
listmethod=nested(tasks).lists
name=Can Start Tasks
stretch=0
textmode=true
type=iterate
valueexpression=IF({canStart}=1,IF({percentComplete}<100,{name},""),"")
valueformat=HTML
width=300

[Jcosta16]

This is very helpful! Is there a way to filter out parent tasks?

[GrahamJarrett]

Yes. You could also add to the IF statement for the field numberOfChildren = 0

[GrahamJarrett]

valueexpression=IF({canStart}=1,IF({numberOfChildren}=0,IF({percentComplete}<100,{name},""),""),"")

[NicholeVargas]

On a project report, you can add the following text mode collection columns to see Completed Milestones and the next/upcoming Milestone (based on predecessor relationships / can start): 

Completed Milestones

listdelimiter=<br>
listmethod=nested(tasks).lists
name=Completed Milestones
stretch=0
textmode=true
type=iterate
valueexpression=IF(!ISBLANK({milestoneID})&&{status}="CPL",{milestone}.{name},"")
valueformat=HTML
width=300

 Next Milestone

listdelimiter=<br>
listmethod=nested(tasks).lists
name=Next Milestone
stretch=0
textmode=true
type=iterate
valueexpression=IF(!ISBLANK({milestoneID})&&{canStart}="true"&&{status}!="CPL",{milestone}.{name},"")
valueformat=HTML
width=300

[Jcosta16]

Thank you!