Conditional Report Filter | Community
Skip to main content
Level 2
October 15, 2019
Question

Conditional Report Filter

  • October 15, 2019
  • 1 reply
  • 433 views
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
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

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