Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.
SOLVED

Collections ValueExpression and Parent Data

Avatar

Level 1

I have built a task report.  I am accessing the Predecessor collection as follows:

displayname=Predecessor Planned Lag
listdelimiter=<p>
listmethod=nested(predecessors).lists
type=iterate
valuefield=predecessor:actualCompletionDate
valueformat=HTML

but what I would really love to do is get the WEEKDAYDIFF of the predecessor Actual completion Date and the current task actualStartDate

 

displayname=Predecessor Planned Lag
listdelimiter=<p>
listmethod=nested(predecessors).lists
type=iterate
valueexpression=WEEKDAYDIFF({predecessor}.{actualCompletionDate}, {CURRENT TASK ACTUAL START DATE})
valueformat=HTML

 

Is it possible to reference a field on the current object within a collection field like this, and if so, how?

Topics

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

haha I hear ya. I think you should think about other dates that might serve the same purpose. Have you looked into using the current task's handoff date? I feel like the handoff date is the date it was handed off from the predecessors, and that would keep you on task without looking upstream into collections.

View solution in original post

4 Replies

Avatar

Community Advisor

that isn't possible at this time. 

Avatar

Level 1

Thanks.  Boo but thanks for the quick reply.

Avatar

Correct answer by
Community Advisor

haha I hear ya. I think you should think about other dates that might serve the same purpose. Have you looked into using the current task's handoff date? I feel like the handoff date is the date it was handed off from the predecessors, and that would keep you on task without looking upstream into collections.

Avatar

Level 1

Well that is helpful.  Didn't even know that was a standard field.  Thank you