How can I create a 30day late task report and leveraging the Recent Activity "Update" field? | Community
Skip to main content
Level 3
March 11, 2021
Question

How can I create a 30day late task report and leveraging the Recent Activity "Update" field?

  • March 11, 2021
  • 2 replies
  • 633 views

I would like to create a report that only shows something along the line of: IF task is Greater than 30 days AND Recent Activity is > 30 days Display on Report. I appreciate any assistance. Currently, I just have, shows tasks that are 30 days late. Current filter looks like this:

numberOfChildren=1

numberOfChildren_Mod=lt

plannedCompletionDate=$$TODAYe-30d

plannedCompletionDate_Mod=lt

project:status=CUR

project:status_Mod=in

projectPortfolioID=5bfc22ed00b20b189229e8201f3742b6 5eb2fb14053aa4b8f8dacbdd1d9b251c

projectPortfolioID_Mod=in

statusEquatesWith=CPL

statusEquatesWith_Mod=ne

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

BradSm3Author
Level 3
March 15, 2021

just bumping for an answer

Heather_Kulbacki
Community Advisor
Community Advisor
March 16, 2021

For "recent activity" are you looking for update comments posted on the task or ANY activity on that task?

For update comments I would try the filter: All Notes >> Entry Date less than $$TODAY-30D

For any activity in the updates feed, I would try the new filter: Journal Entries >> Entry Date less than $$TODAY-30D