Expand my Community achievements bar.

How to filter a report by the date the project status changed?

Avatar

Level 2

I keep a report for my team of projects we moved to a "dead" status. The list is growing, so we wanted to set up a filter for items moved to the "dead" status within the past year. I can't seem to locate a good way to filter a list of projects by the date in which they were moved to a specific status. Does anyone know how to do that?

Topics

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

2 Replies

Avatar

Level 10

Hi - when I need to find this out, I use a Note report and do a filter where "audit text contains Cancelled". I use a similar process on a custom dashboard in a layout template so people can see who completed tasks in a project. You could do that in a portfolio easily.

0694X00000C1gujQAB.png

Avatar

Level 5

@Anthony Imgrund‚ Didn't know I needed this until today where a user asked for something similar! Wasn't entirely sure if it was possible Thanks for answering this one!