I would like to add a "current task" column to an active project report - any ideas?

[JeremyNe]

I would like to add a column to an active project report (any project in the "current" state) that shows what task is happening NOW... or what is the next task that needs to be completed.

I would imaging that there's some text mode trickery that needs to happen, any suggestions would be appreciated! Thanks to all!

[Richard_Le_]

Hi Jeremy,

With credit to WF-Pro.com . . . . there's some example text mode code on here that should achieve exactly what you are looking for.

The below code will return the name and planned completion date of all tasks that are currently being working on, or can start in a project

valueexpression=IF({numberOfChildren}=0,IF({canStart},IF(CONTAINS("CPL",{status}),"",CONCAT({name}," - ",{plannedCompletionDate}))))

listdelimiter=

listmethod=nested(tasks).lists

valueformat=HTML

displayname=Current Task

textmode=true

type=iterate

Best Regards,

Rich.