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

Next task due in a Project Report

  • July 9, 2026
  • 1 reply
  • 6 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?

1 reply

SuryaLakhani
Level 4
July 9, 2026

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