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

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

  • July 8, 2025
  • 3 replies
  • 542 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

kautuk_sahni
kautuk_sahni
Employee
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
-JC
-JCAccepted solution
New Participant
July 8, 2025

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

M
mdeancherryAuthor
New Participant
July 8, 2025

Yep, that did it, thanks.

 

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

    -JC
    -JC
    New Participant
    July 9, 2025

    Glad to hear it!

    skyehansen
    skyehansen
    New Participant
    July 8, 2025

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

    M
    mdeancherryAuthor
    New Participant
    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
    skyehansen
    New Participant
    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},"")

      Terms & ConditionsAccessibility statement

      Loading footer...