Next task due in a Project Report | Community
Skip to main content
Tracy_Parmeter
Tracy_Parmeter
Level 3
July 9, 2026
Question

Next task due in a Project Report

  • July 9, 2026
  • 2 replies
  • 67 views

We have a Project report and have been asked to add a column that pulls in the next task that is due. Does anyone know how to accomplish this? 

 

The closest I have been able to get is for it to pull in all incomplete tasks, but they come in all out of order. Even though the documentation says it defaults to the order of the tasks in the timeline. This is the code I am using currently.

displayname=Next Task Due
listdelimiter=<br>
listmethod=nested(tasks).lists
type=iterate
valueexpression=IF({status}!="CPL",CONCAT({name}," - ",{plannedCompletionDate}),"")
valueformat=HTML

 

I tried replacing .lists with .first but that didn’t work either.

Anyone have any suggestions?

2 replies

SuryaLakhani
SuryaLakhani
Level 4
July 9, 2026

Hi, if you are using predecessors, you can use “canStart” to filter for tasks that are next!

KellieGardner
Community Advisor and Adobe Champion
KellieGardnerCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
July 13, 2026

How are you defining “next task that is due”?

 

How about any task that is ready to start but not complete?

displayname=open tasks ready to start
listdelimiter=<div>
listmethod=nested(tasks).lists
type=iterate
valueexpression=IF(ISBLANK({actualCompletionDate}),IF({numberOfChildren}='0' && {canStart}="true",CONCAT({name}," | Due Date:",{plannedCompletionDate})))
valueformat=HTML

 

Terms & ConditionsAccessibility statement

Loading footer...