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?


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 help categorize Community content and increase your ability to discover relevant content.

1 Reply


Level 10

Hi Jeremy,

With credit to . . . . 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}))))




displayname=Current Task



Best Regards,