Calculated Expression collection question

[CameronHo]

I am creating a Project report where I am trying to reference a collection in the view. What I want to happen in this column is to show the assignee of all tasks within the project that have "draft" in the task name. Here is the text mode code I have prepared so far: displayname=Draft Assignee(s) listdelimiter= listmethod=nested(tasks).lists textmode=true type=iterate valueexpression=IF({tasks:name}="Draft",{TASK:assignedTo:name}) valueexpression_Mod=cicontains valueformat=HTML I have also tried this: displayname=Draft Assignee(s) listdelimiter= listmethod=nested(tasks).lists textmode=true type=iterate valueexpression=IF({tasks:name}="Draft",{assignedTo:name}) valueexpression_Mod=cicontains valueformat=HTML I have had some trouble finding documentation on how to properly utilize modifiers in these types of valueexpressions. Anyone able to help figure out how to make this work? Thanks. Cameron Howitt

[Doug_Den_Hoed__AtAppStore]

Hi Cameron, Here's an "https://support.workfront.com/hc/en-us/articles/216599038-Understanding-Text-Mode">Understanding Text Mode overview, a comprehensive recap of "https://support.workfront.com/hc/en-us/articles/217196767-Understanding-Calculated-Data-Expressions">Understanding Calculated Data Expressions , within which I'd suggest you leverage the "CONTAINS" expression (instead of the IF, since the Tasks you're looking for 'have "draft" in the name' ) in your valueexpression, as follows: CONTAINS CONTAINS(findText, withinText) Returns true if the findText string is found within the withinText string Text Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

[SarahNau]

Morning Cameron, I would try this: displayname=Draft Assignee(s) listdelimiter=

listmethod=nested(tasks).lists textmode=true type=iterate valueexpression=IF(CONTAINS("Draft",{name}),{assignedTo}.{name}) valueformat=HTML Note that "Draft" is case sensitive! Good Luck! Sarah Nau Dominium Inc.