Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

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

Level 3

just bumping for an answer

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