Create a report to identify the Oldest and/or Newest task in each project | Community
Skip to main content
ElizaBarryGuild
ElizaBarryGuild
Level 2
May 21, 2025
Solved

Create a report to identify the Oldest and/or Newest task in each project

  • May 21, 2025
  • 2 replies
  • 370 views

Hello community!

 

I am hoping to create a report that shows the Oldest task in a project (i.e. the FIRST task). We would like to track projects that take more than one sprint to complete and currently, we track the sprint ID on each task with a custom field.

It would be okay if this is 2 reports but ideally it would be:

 

Project Names | Oldest Task Name | Oldest Task Due Date | Oldest Task custom field | Newest Task Name | Newest Task Dues Date | Newest Task Custom field

 

the tasks could also be on 2 lines for each project, I don't mind.

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

@elizabarryguild - 

 

I would do this with a task report. You can filter for the task=1 and then for the task number that equals the total task count of the project to get your final task.

 

 

 

You'll have to use text mode for the last task filter.

 

OR:1:taskNumber=1 OR:1:taskNumber_Mod=eq taskNumber=FIELD:project:totalTaskCount taskNumber_Mod=eq

 

2 replies

KellieGardner
Community Advisor
KellieGardnerCommunity AdvisorAccepted solution
Community Advisor
May 27, 2025

@elizabarryguild - 

 

I would do this with a task report. You can filter for the task=1 and then for the task number that equals the total task count of the project to get your final task.

 

 

 

You'll have to use text mode for the last task filter.

 

OR:1:taskNumber=1 OR:1:taskNumber_Mod=eq taskNumber=FIELD:project:totalTaskCount taskNumber_Mod=eq

 

    kautuk_sahni
    Community Manager
    kautuk_sahniCommunity Manager
    Community Manager
    July 29, 2025

    @elizabarryguild Just checking in — were you able to resolve your issue?
    We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!

    Kautuk Sahni
    Terms & ConditionsAccessibility statement

    Loading footer...