Calculated Expression collection question | Community
Skip to main content
C
CameronHo
Level 3
June 20, 2018
Question

Calculated Expression collection question

  • June 20, 2018
  • 2 replies
  • 544 views
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
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
June 21, 2018
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
Adobe Employee
SarahNauAdobe Employee
Adobe Employee
June 21, 2018
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.
Terms & ConditionsAccessibility statement

Loading footer...