Group task report by "contains" of task name | Adobe Higher Education
Skip to main content
MattEl5
MattEl5
Level 3
January 15, 2025
解決済み

Group task report by "contains" of task name

  • January 15, 2025
  • 1 の返信
  • 449 ビュー

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! 


このトピックへの返信は締め切られました。
ベストアンサー 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 の返信

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion回答
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.

契約条件Accessibility statement

Loading footer...