Expand my Community achievements bar.

Interested in applying to or sharing a Workfront-related job opportunity? Check out the Workfront Job Board!

Task Report not sorting by Project custom data column


Level 1

I have a task report that is not allowing sorting for a few of the columns. The two specific columns that are not allowing the sorting function are pulling custom data (data from custom form) at the project level. I have a few other columns that are pulling in similar data (custom form at project level) and is allowing sorting by those columns. Does anyone have any insight into this issue?


Specifically, the columns in this screenshot for Project: Flight Start Date and Project: Flight End Date are not sorting properly. If I click on those to sort, the data will sort, but it isn't sorting properly by these columns. 


Screenshot 2023-05-17 at 4.34.59 PM.png

2 Replies


Level 10

Are your date fields text or date type? If it's a text field, it won't sort correctly.


Level 1

Randy, thank you for the insight. I believe that might be the case. The data for the columns I'm running into the issue with are populating from a Fusion integration with Salesforce. Looking at the custom form where these are coming from, it does appear the fields are set up as Text fields versus date fields. 


I cannot confirm this, but I have users who are saying they were able to sort these columns previously, and now are not able to. They could be confused, but just trying to cover all bases and make sure something hasn't changed recently. 

page footer