Task Collections Field - Order

[AlisonJane]

Hi Workfront World!

I have 2 questions: 

1: I am trying to create a report that shows all tasks & due dates in the same field. Currently I am able to get this to happen using this expression: 

valueexpression=CONCAT({name}," ",{plannedCompletionDate},", ")

HOWEVER, the tasks are not in order. Is there a way to have the tasks show up in order based on how they appear in the job itself?

2: Also wondering if there is a way to show only current tasks. I tried using this expression: 

valueexpression=IF(ISBLANK({milestoneID})," ",CONCAT({name},"; ",{plannedCompletionDate}))

However, I end up with a blank field. 

Any ideas would be greatly appreciated :). 

Thank you!

Alison 

[skyehansen]

1) One of the top limitations of a collection view is what you're asking about -- scroll down to the Limitations of a Collection View section to find out more about this.

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/reference-collec...

2) This text mode seems to work fine... is it possible that you have no milestones set?