Skip to main content
Level 2
November 20, 2025
Question

How to use task dates as criteria for a project level report?

I'm trying to create a report that shows how many projects have a task planned date that is past due by project manager.
So I either need to use the task-level report I already have and create a chart by unique value of project name, OR I need to create a project-level report that draws on task planned dates within that project.

 

Has anyone created anything like this?

2 replies

kautuk_sahni
Adobe Employee
Adobe Employee
February 2, 2026

 ​@Lyndsy-Denk ​@Richard_Carlson ​@VicSellers ​@Doug_Den_Hoed_AtAppStore ​@monicacardoso ​@Ross_Barton Wanted to loop you in to see if you have any thoughts or best practices to share on this topic. Your insights would be highly appreciated!

Translate
Kautuk Sahni
Doug_Den_Hoed_AtAppStore
Community Advisor
Community Advisor
February 2, 2026

Thanks for the tag, ​@kautuk_sahni.

 

​@Knelis13, if your goal is to show each TASK that is past its due by project manager, copying the Task report you already have and formatting it accordingly would be a good approach.

 

On the other hand, if you instead simply want to see each PROJECT with at least one Task that is past due, I’d instead suggest a Project report using a (more advanced) EXISTS filter, which you can learn about here.

 

Regards,

Doug

Translate
Learn more at www.atappstore.com, email doug.denhoed@atappstore.com, or tag me here @Doug_Den_Hoed_AtAppStore.