Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

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

Avatar

Level 3

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

2 Replies

Avatar

Community Advisor

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