Thank you,  Ill see if that helps, but i feel might have the same issue as the grouping suggestion which only works if the code is always in the same field.

I tried the suggestion to report in groups and it sort of helps. However it is possible for the sales person to enter the code in one of three fields. We have three fields in a custom form, opp code 1, opp code 2, opp code 3. This custom form usually starts in a request and then later is converted i...

Hi,We use a field on a custom form to create a link between projects & salesforce, it generally works well. But from time to time a sales person will enter the same opportunity code into multiple projects, usually because an earlier project used a particular opportunity and that project was wrapped ...

Hi, I have created a dynamic board to pull in Workfront actions and update the action status from the board. All working fine with my custom status.  When these actions are eventually converted into projects the status is managed from the project status (again working fine). As all projects start wi...