Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

Avatar

Level 2

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!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 10

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.