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?

[MikeMcGovern]

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

[Doug_Den_Hoed__AtAppStore · Accepted solution]

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

[MikeMcGovern]

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