Skip to main content
Jcosta16
Level 2
Apr 8, 2024 7:59 PM UTC
Solved

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

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.
GrahamJarrett
GrahamJarrettAccepted solution
Level 4
Apr 9, 2024 12:24 PM UTC

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 in thread

6 replies

GrahamJarrett
GrahamJarrettAccepted solution
Level 4
Apr 9, 2024 12:24 PM UTC

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

Translate
Jcosta16Author
Level 2
Apr 11, 2024 1:46 PM UTC

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

Translate
GrahamJarrett
GrahamJarrett
Level 4
Apr 11, 2024 3:11 PM UTC

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

Translate
    NicholeVargas
    Adobe Employee
    NicholeVargasAdobe Employee
    Adobe Employee
    Apr 10, 2024 10:36 PM UTC

    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

     

    Translate
      Jcosta16Author
      Level 2
      Apr 15, 2024 12:56 PM UTC

      Thank you!

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...