Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

Avatar

Level 3

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!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

0 Replies

Avatar

Level 10

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%2FRe...

Avatar

Level 3
Thanks, Randy I really appreciate your help and will let you know if I have any additional questions. Michelle McAnelly Productivity Manager. Investment Strategy M 612 209 2226 MMcAnelly@paraport.com PARAMETRIC | 3600 MINNESOTA DRIVE | SUITE 325 | MINNEAPOLIS, MN 55435 parametricportfolio.com<>