Skip to main content
C
ChristianSi6
Level 2
July 27, 2023
Question

Count Number of Issues with specific words

  • July 27, 2023
  • 3 replies
  • 879 views

I am trying to add a column to a project report to calculate the number of issues on the project that contain the words Change Order.  So far, I can't get anything to return.  Any thoughts on where I'm going wrong with this?

 

valueexpression=SUM(IF(CONTAINS('Change Order',{OPTASK}.{name})=true))

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

3 replies

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
July 27, 2023

this looks like you are trying to do it from a project report? If so, this won't work at all.

(read this link for more info https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/text-mode/reference-collections-report.html?lang=en )

 

If you're trying to do it from an issue report, then you don't need to say "optask" (this ALSO isn't actually the object name you would use, by the way, but since you're in an issue report, it's simply not needed)

 

 

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity Advisor
Community Advisor
July 27, 2023

You don't even need text mode for this. Create an Issue report instead and filter to project name equals XYZ and issue name contains change order. Or if that is across many projects and you want to see issue names containing change order in any project, remove the project name filter.

If this helped you, please mark correct to help others : )
NicholeVargas
Adobe Employee
NicholeVargasAdobe Employee
Adobe Employee
July 31, 2023

You cannot SUM values in a collection (issues are a collection of projects) so like a few customers mentioned below, you can either create an issue report that filters for this specific project, or use text mode to generate a list of all issues that contain the word, Change Change, and manually count.

Terms & ConditionsAccessibility statement

Loading footer...