Is there a way to truncate a project name in a report? | Community
Skip to main content
Level 3
April 7, 2022
Question

Is there a way to truncate a project name in a report?

  • April 7, 2022
  • 1 reply
  • 734 views

We just started adding a calculated reference number to the end of our project and issue names that looks like this - Workfront Project Name (2022-2-123456). That field is now appearing in an executive report and they don't want to see the ref # just the Workfront project Name. Is there a way to use Text mode to remove the ref code and brackets on all and only show the original project name? Thanks!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

RandyRoberts
Community Advisor
Community Advisor
April 8, 2022

Here is a Project description column example that displays the first 100 characters. If you want the project name, just change {description} to {name}

valueexpression=CONCAT(LEFT({project}.{description},100),"...") valueformat=HTML

displayname=Project Description

The CONCAT is just there to add "..." to the end of the description, that way a user knows that there may be more text that they're just not seeing in the report. You can omit the CONCAT() portion if you choose, so it would just be:

valueexpression=LEFT({description},100).

If you want to get REALLY fancy and only add the "..." when the description is > 100 characters, you'd use this:

valueexpression=IF(LEN({project}.{description})>100,CONCAT(LEFT({project}. {description},100),"..."),LEFT({project}.{description},100))

valueformat=HTML

displayname=Project Description

That being said, I think what you really want is to REMOVE a specific number of characters from the end. I don't know of a straight forward way of doing that. This page may help you though: https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FReports_and_Dashboards%2FReports%2FCalc_Cstm_Data-Reports%2Fcalculated-data-expressions.html&_LANG=enus

Level 3
April 8, 2022

Thanks, Randy I really appreciate your help and will let you know if I have any additional questions. Michelle McAnelly Productivity Manager. Investment Strategy