Report to show projects that were closed or killed last month

Forum|Forum|3 months ago
October 13, 2025
2 replies
526 views

Hi all,

I'm trying to create a report that shows a list of projects that were closed or killed last month.

I'm struggling to find a way to filter for projects that had their status changed in a certain date range.

Any ideas? I feel like I must be missing something here.

Thank you!

Workfront

Best answer by skyehansen

I think the only way to do this at this stage is a journal entry report. Have you looked down this path at all?

A

AmyReilly

Level 4

This post may help (reference example #1):

Save Time Using Calculated Fields to Capture Dates... - Adobe Experience League Community - 518237

You can create a custom field that tracks the date the project was closed and then filter on that field.

skyehansen

Accepted solution

I think the only way to do this at this stage is a journal entry report. Have you looked down this path at all?

ChloeWYAuthor

Level 6

Hi @skyehansen , I got this report working.

Now I'm trying to make a report that shows projects that received Gate 3 approval in the last month. Do you have any resources you can point me towards? I understand journal entry reports to find specific projects based off things that happened at the project level. I'm struggling to find something that can find projects based off an action at the task level.

skyehansen

sorry, what’s gate 3 approval and how is it configured?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded