Sorting by "Total Number of Days" in Text Mode – Suggestions Needed

[AndersonDe2]

• What (The Issue):
  • We’re creating a proofing report to track proofs that are taking the longest to get approved. As part of the report, we’ve added a calculated field called “Total Number of Days”, which shows the number of days from the proof’s creation date to its approval date.
    However, we’re running into a problem: we can’t sort this field when using text mode, as sorting doesn’t seem to behave correctly.
• Why (The Goal):
  • The goal is to highlight proofs with the longest approval times at the top of the report. This would help stakeholders quickly identify bottlenecks and take action. Sorting by the total number of days is a key part of making this report useful.
• How (The Challenge / Request):
  • Since we’re using text mode to customize the report, it seems to be blocking standard sorting functionality, especially for calculated fields like “Total Number of Days.”
  • We're looking for suggestions, workarounds, or best practices to enable sorting on this calculated field while still using text mode.
    Has anyone successfully done this before or found an alternative approach?

[AbiBeggs]

Hello! for your calculated field, is that formatted as a number?

We were trying to do something similar but our calculated field was formatted as text and not a number. Updating that helped solve it for us.