Expand my Community achievements bar.

Conditional Report Filter

Avatar

Level 2
One of my reports pulls a date based on the task field name (R1 into Proofing). It's working, but how can I pull it based on Contains or Starts with, rather than =. I noticed some of the tasks weren't labeled exactly the same. displayname=R1 Proofing Planned Start Date listdelimiter=
listmethod=nested(project.tasks).lists textmode=true type=iterate valueexpression=IF({name}="R1 into Proofing",{plannedStartDate},"") valueformat=HTML Chandra Asken San Francisco Symphony
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 3
Hello Chandra, You should be able to use this ... valueexpression=IF(CONTAINS("R1 into Proofing",{name}),{plannedStartDate},"") Patricia Greene JLL