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
Solved! Go to Solution.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Hey Doug - thanks for the recommendation. I can see what you mean from a performance perspective!
Views
Replies
Total Likes
Views
Likes
Replies