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? | Community
Skip to main content
M
mmcgovern
Level 3
February 12, 2024
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?

  • February 12, 2024
  • 1 reply
  • 613 views

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

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 Doug_Den_Hoed_AtAppStore


Hi @mmcgovern,

 

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

1 reply

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity AdvisorAccepted solution
Community Advisor
February 12, 2024


Hi @mmcgovern,

 

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

M
mmcgovernAuthor
Level 3
February 12, 2024

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

Terms & ConditionsAccessibility statement

Loading footer...