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 do you filter to show the most recent issues submitted in a project?

Avatar

Level 3

I'm trying to build a report for a new weekly updates process our firm is implementing. Our project managers will be submitting weekly updates using project queue and filling in custom fields that will be used in the report. However, I only want the most recent weekly update to appear in the report rather than every single historical update. How would I build a filter to accomplish this?

Topics

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

1 Reply

Avatar

Level 10

Hi Jason,

Our Automatic Weekly Status Reporting addresses this concept (and our Executive Status Report solution implements it), but if I am following your logic correctly, given that your project managers will submit their latest official update in custom form fields via a project queue, and provided there is a some regular cadence, perhaps you could simply filter by Entry Date (eg greater than $$TODAY-7d) to only pull the latest status.

Regards,

Doug