Is there a way to truncate a project name in a report? | Adobe Higher Education
Skip to main content
Level 3
April 7, 2022
Pergunta

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

  • April 7, 2022
  • 1 resposta
  • 739 Visualizações

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!

Este tópico foi fechado para respostas.

1 Resposta

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