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

[ElizaBarryGuild]

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.

[KellieGardner · Accepted solution]

@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]

@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!