Group task report by "contains" of task name | Community
Skip to main content
MattEl5
MattEl5
Level 3
January 15, 2025
Solved

Group task report by "contains" of task name

  • January 15, 2025
  • 1 reply
  • 449 views

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! 


This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by skyehansen

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.

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe ChampionAccepted solution
January 15, 2025

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.

Terms & ConditionsAccessibility statement

Loading footer...