Expand my Community achievements bar.

SOLVED

What can I add to a text mode column in a project report to sort milestone data in sequence order from a nested task list?

Avatar

Level 2

I am using the following text mode to extract milestone data from a project's task list for a column in a task report. However the milestones are showing up out of order and I want them to appear in sequence order. Is there anything I can add to the text mode to sort the output in each cell by milestone sequence order?

 

Text Mode

valueexpression=IF({milestoneID}!="",CONCAT({milestone}.{sequence},") ",{milestone}.{name}," - ",{percentComplete},"% Complete"))
listdelimiter=<br>
listmethod=nested(tasks).lists
valueformat=HTML
displayname=Milestone Progress
width=500
textmode=true
type=iterate
usewidths=true

 

Illustrative Output

1) Design - 0% Complete
3) Asset Delivery - 0% Complete
2) Final Editorial Review - 0% Complete
0) Copy - 17.78% Complete

 

Desired Output

0) Copy - 17.78% Complete

1) Design - 0% Complete

2) Final Editorial Review - 0% Complete

3) Asset Delivery - 0% Complete

1 Accepted Solution

Avatar

Correct answer by
Community Advisor


Hi @MikeMcGovern,

 

Natively, although creating a sorted list of milestones on a Project report is “expensive” (from a performance perspective) and a bit complicated, it is possible using these techniques.

 

Regards,

Doug

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor


Hi @MikeMcGovern,

 

Natively, although creating a sorted list of milestones on a Project report is “expensive” (from a performance perspective) and a bit complicated, it is possible using these techniques.

 

Regards,

Doug

Hey Doug - thanks for the recommendation. I can see what you mean from a performance perspective!