Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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 4

@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!