Looking for help pulling and sorting project milestones into a project report | Community
Skip to main content
E
ErinMc1
Level 2
January 22, 2021
Question

Looking for help pulling and sorting project milestones into a project report

  • January 22, 2021
  • 2 replies
  • 489 views

We have figured out how to pull the milestone dates into a field (text below).

However, it appears that these get sorted based on the last one to be updated dropping to the bottom of the list, which puts it out of any logical order.

What we want to do is sort this field by Date - so they are in actual time order of the milestones.

Option B would be to sort alphabetically, but that would require us updating the name of the milestones (doable, but not ideal).

Any ideas on text editing to sort ascending from a list in a field for "plannedCompletionDate"?

displayname=Milestones

listdelimiter=<br>

listmethod=nested(tasks).lists

textmode=true

type=iterate

valueexpression=IF(!ISBLANK({milestone}.{ID}),CONCAT({milestone}.{name}," = ",{plannedCompletionDate}),"")

valueformat=HTML

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

S
SarahNa
Level 6
January 22, 2021

Hi Erin,

Unfortunately I do not think this is possible. If you check out this article, you can see that there are limitations of a collections report:

Limitations of a collection View

Consider the following limitations when you are building a collection view:

  • You cannot control the order in which collection data is displayed.

https://one.workfront.com/s/document-item?bundleId=workfront-classic&topicId=Content%2FReports_and_Dashboards%2FReports%2FText_Mode%2Freference-collections-report.html&_LANG=en

Sorry that I don't have a better answer!

imgrund
Adobe Employee
imgrundAdobe Employee
Adobe Employee
January 22, 2021

Hi - can confirm what Sarah said. You have no control over sorting and conditional formatting for items inside a collection.

If it is super important and you have some money, we contacted Doug at AtApp to help use create a project status report that has them sorted and conditionally formatted. (He was also able to give some pretty additions like client logo insertion and brand coloring :) )

Terms & ConditionsAccessibility statement

Loading footer...