Reporting question - Project collection report where column is tasks that can start within the project | Community
Skip to main content
J
Jcosta16
Level 2
April 8, 2024
Solved

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

  • April 8, 2024
  • 2 replies
  • 1293 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by GrahamJarrett

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

2 replies

GrahamJarrett
GrahamJarrettAccepted solution
Level 4
April 9, 2024

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

J
Jcosta16Author
Level 2
April 11, 2024

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

GrahamJarrett
GrahamJarrett
Level 4
April 11, 2024

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

    NicholeVargas
    Adobe Employee
    NicholeVargasAdobe Employee
    Adobe Employee
    April 10, 2024

    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

     

      J
      Jcosta16Author
      Level 2
      April 15, 2024

      Thank you!

      Terms & ConditionsAccessibility statement

      Loading footer...