Can you include a "task name includes" descriptor in a project report? | Community
Skip to main content
M
mdeancherry
Level 3
July 8, 2025
Solved

Can you include a "task name includes" descriptor in a project report?

  • July 8, 2025
  • 3 replies
  • 545 views

I've got a project report that I want to include when the next Partner Proof is. I can get it to work using the specific task name like "Partner Proof 1" using the code below. Is there a way to code it so it pulls in any task that includes "Partner Proof" as part of the name (so, Partner Proof 1, Partner Proof 2, etc.)? 

 

displayname=Partner Proof 1
listdelimiter=<p>
listmethod=nested(tasks).lists
shortview=true
type=iterate
valueexpression=IFIN({name},"Partner Proof 1",{plannedCompletionDate},"")
valueformat=HTML
Best answer by -JC

I'm wondering if you need to use IF(CONTAINS instead of IFIN?

3 replies

skyehansen
Community Advisor
skyehansenCommunity Advisor
July 8, 2025

is something bad happening if you just take out all the 1's?

M
mdeancherryAuthor
Level 3
July 8, 2025

If I take it out of the code, it doesn't work since the tasks are called Partner Proof 1 (or Partner Proof 2, etc). I suppose we could change all our projects to not include the number in the task name but the team like the easy reference. I am looking for the code change that would make it say "tasks that include the words "Partner Proof" even if that isn't the whole name" but I don't do a lot of text mode edits so I'm not sure how to do it.

 

skyehansen
Community Advisor
skyehansenCommunity Advisor
July 8, 2025

ohhh, gotcha. -JC's suggestion below would/should work.

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/calculated-custom-data/calculated-data-expressions

 

Syntax is listed as:

* CONTAINS(findText, withinText),

* IF(condition, trueExpression, falseExpression)

 

so, that kind of boils down to

IF(CONTAINS("Partner Proof",{name}),{plannedCompletionDate},"")

    -JC
    -JCAccepted solution
    Level 6
    July 8, 2025

    I'm wondering if you need to use IF(CONTAINS instead of IFIN?

    M
    mdeancherryAuthor
    Level 3
    July 8, 2025

    Yep, that did it, thanks.

     

    IF(CONTAINS("Partner Proof",{name}),{plannedCompletionDate},"")

      -JC
      -JC
      Level 6
      July 9, 2025

      Glad to hear it!

      kautuk_sahni
      Community Manager
      kautuk_sahniCommunity Manager
      Community Manager
      September 22, 2025

      @mdeancherry  we noticed your question and invite you to our [Workfront AMA] Ask Me Anything about Workfront System Smarts & Strategic Starts on Wed, Oct 29, 2025 | 9–10 AM PDT. Experts will answer questions on topics like: day-to-day system tasks, strategic planning, Reporting, Adoption, System Maintenance, Notifications, Governance, Roadmapping, and Custom Forms. Post your questions in advance to ensure they’re answered. Reminder: All AMAs are TEXT-ONLY—no video or recording. RSVP & submit questions in advance here: https://adobe.ly/46xKfHM 

      Kautuk Sahni
      Terms & ConditionsAccessibility statement

      Loading footer...