Expand my Community achievements bar.

SOLVED

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

Avatar

Level 2

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.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 6

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

View solution in original post

6 Replies

Avatar

Correct answer by
Level 6

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

Avatar

Level 2

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

Avatar

Level 6

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

Avatar

Level 6

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

Avatar

Employee Advisor

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