Question
Is there a way to truncate a project name in a report?
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!