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

[mdeancherry]

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

[skyehansen]

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

[mdeancherry]

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]

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

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

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 · Accepted solution]

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

[mdeancherry]

Yep, that did it, thanks.

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

[-JC]

Glad to hear it!