Expand my Community achievements bar.

Got questions about Workfront Governance? Join our upcoming Ask Me Anything session on February 12th!

Group task report by "contains" of task name

Avatar

Level 2

Hi Gurus!! 
Trying to get a report to group tasks initially by under either "COPY" or "DESIGN", and then by project name

based on if the task name has the word "Copy" in it, or the word "design". This way copy/design teams could see everything relating to them, even if it was an ad hoc task not in templates.

Been muddling around with text mode for groupings and after reading i think its around valuefield but not getting exact results i want to see. (maybe its Valueexpression?)

group.0.valuefield=IF(CONTAINS("copy",{name}),"")

also wondering how i would say to the program to put things under 1 of these 2 headings,
so If name Contains "copy" put under "Copy" group. If name Contains "design" put under "Design" group.

Hoping this makes sense to all and thanks for any help/solutions/guidance! 


Topics

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

1 Reply

Avatar

Community Advisor

You'd have to make a calculated field for this and add it to all tasks. Then group by the calculated field.

 

If the name contains Copy, the value of the calculated field is "Copy", and so on.