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

Looking for help on a task report.

Avatar

Level 2

Does anyone know how to display a list of tasks, the planned completion date of those tasks along with that tasks predecessors and their predecessors planned completion date?

Example

Task Name Planned Completion Date Predecessor Predecessor Planned Completion Date

Task 1 1/25/22 3 3/15/22

Topics

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

3 Replies

Avatar

Level 10

Hi Nicole, a task can have multiple predecessors so you need to do a collection.

I have this text mode I've used in the past. It should the task number, name, and planned completion date of the predecessors for a task

displayname=Predecessors

listdelimiter=<br>

listmethod=nested(predecessors).lists

textmode=true

type=iterate

valueexpression=CONCAT("(",{predecessors}.{taskNumber},") ",{predecessors}.{name}," - ",{predecessors}.{plannedCompletionDate})

valueformat=HTML

Hope that helps.

Avatar

Level 2

Thanks so much! Unfortunately, this did not work for me.

It didn't error out or produce a report.

Avatar

Level 10

Hi Nicole, So sorry... the code was wrong. #facepalm

displayname=Predecessors

listdelimiter=<br>

listmethod=nested(predecessors).lists

textmode=true

type=iterate

valueexpression=CONCAT("(",{predecessor}.{taskNumber},") ",{predecessor}.{name}," - ",{predecessor}.{plannedCompletionDate})

valueformat=HTML

Here is what it looks like:

0694X00000HDYOtQAP.png