Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!
SOLVED

Task Report not sorting by Project custom data column

Avatar

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

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

Avatar

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.