Report showing projects that have moved from one program to another | Community
Skip to main content
New Member
August 4, 2025
Solved

Report showing projects that have moved from one program to another

  • August 4, 2025
  • 1 reply
  • 310 views

Hi,

I am trying to create a report that will show when a project moves from one program to another.  This is for awareness for another team that doesn't always know when the project program changes and with the volume of projects within the program it's hard to see these shifts.  I tried a journal entry report but was hitting roadblocks on getting the right filter option to make this happen. Any ideas on types of reports or ways to complete this? 

Thank you

Best answer by skyehansen

I encourage you to keep going with the journal entry report!

 

1) You will find it easier if you test your report in the preview sandbox as nothing much should be happening there. Your initial filter is as simple as "entry date is today" (or if you've been in the sandbox for a few minutes, maybe look at your watch and have it be "entry date is greater than Aug 4 at XX PM") and you will then begin to pull up every change you make, that your system tracks (see below handy hint).

 

2) I would start by including the Old Text Value and New Text Value columns in your view. These are the most likely places that would store that type of a change.

 

3) After you've created your report (hint: your report should start with no rows), you can change a project's program, and see if it shows up in your report (hint: after you make this change, your report should have at least one new line)

 

Handy hint: If you make a change to a program, and it doesn't show up on your report, it means you need to go to the setup area and add the program ID to your tracked fields area. This is under Interface / Update Feeds. The reason certain changes don't show up is because Workfront doesn't track everything, in particular the thing that isn't showing up. You have a limited ability to track things (for instance, I don't think you can track calculated fields), but the program ID should not be an issue.

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe ChampionAccepted solution
August 4, 2025

I encourage you to keep going with the journal entry report!

 

1) You will find it easier if you test your report in the preview sandbox as nothing much should be happening there. Your initial filter is as simple as "entry date is today" (or if you've been in the sandbox for a few minutes, maybe look at your watch and have it be "entry date is greater than Aug 4 at XX PM") and you will then begin to pull up every change you make, that your system tracks (see below handy hint).

 

2) I would start by including the Old Text Value and New Text Value columns in your view. These are the most likely places that would store that type of a change.

 

3) After you've created your report (hint: your report should start with no rows), you can change a project's program, and see if it shows up in your report (hint: after you make this change, your report should have at least one new line)

 

Handy hint: If you make a change to a program, and it doesn't show up on your report, it means you need to go to the setup area and add the program ID to your tracked fields area. This is under Interface / Update Feeds. The reason certain changes don't show up is because Workfront doesn't track everything, in particular the thing that isn't showing up. You have a limited ability to track things (for instance, I don't think you can track calculated fields), but the program ID should not be an issue.

MeganDi2Author
New Member
August 5, 2025

Thank you Skye!  You helped get me on the right track.  I can now see a program ID change note on my report.  Any ideas on how I would filter to only show program changes, though?  I used the filter of "Journal Entry Change Type to Edit" since Edit is the change type I saw when the program changed but it's still pulling all other edit changes that happen and I'm not sure.  I've been playing with different filters, how to only show the program changes, but nothing seems to be working.  

skyehansen
Community Advisor and Adobe Champion
August 5, 2025

you can add to your filter. It doesn’t have to be just one thing. In addition to the edit, maybe you filter on the new text value as well, or the object scope? If you have these columns in your report you can see how they’re getting filled in?