Sorting/Ordering Task Info on Project Report | Community
Skip to main content
L
LaraNu1
Level 2
March 16, 2026
Question

Sorting/Ordering Task Info on Project Report

  • March 16, 2026
  • 1 reply
  • 18 views

I’m working with this expression to bring some Task data onto a Project report. Each project will have multiple tasks that meet this criteria (ie multiple children under the Bottling parent).

 

Is there a way to tell the report to put the outputs in a certain order - ideally sorted by the Planned Start Date. Right now it seems to put them in an unpredictable order, maybe affected by the task status or latest update…I can’t figure out exactly what it’s using to reorder the outputs.

 

displayname=Itemslistdelimiter=<br>listmethod=nested(tasks).liststype=iteratevalueexpression=IF(CONTAINS("Bottling",{parent}.{name}),CONCAT({plannedStartDate}," • ",{name}," • ",{DE:SKU#}," • ",{DE:Estate Bottling Volume}," ",{DE:Estate Bottling UOM}))valueformat=HTML

1 reply

Patrick-antegma
Patrick-antegma
Level 4
March 16, 2026

Hi ​@LaraNu1,

 

With listmethod=nested(tasks).lists, Workfront treats the tasks as a collection view, and Adobe’s docs explicitly say you cannot control the order in which collection data is displayed. So there isn’t a text-mode line you can add here to force those task rows to sort by plannedStartDate within the Project report column. See  https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/text-mode/reference-collections-report#limitations-of-a-collection-view

 

Best workaround options:

  1. Use a Task report instead of a Project collection column
    Filter for the Bottling child tasks there, then sort the report by Planned Start Date. That gives you true sortable rows.

  2. Keep the Project report, but accept the collection order
    Good if you only need a quick rollup and not reliable sequencing.

  3. Split the data into separate columns for known task slots
    Only practical if you have a fixed small number of matching tasks.

If you want, I can also rewrite your text mode into a Task report version that shows:
Project Name • Planned Start Date • Task Name • SKU# • Volume • UOM
and sorts cleanly by Planned Start Date.

L
LaraNu1Author
Level 2
March 16, 2026

Thanks for this info. I was hoping to avoid using a Task report because I also want Project data to be visible on the report and its just messy to have it repeated on every row for each task. But that may be my best / only option!

Terms & ConditionsAccessibility statement

Loading footer...