Text Mode Help! I have a collections report that has worked for us until just recently. Due to our new process I need to add a clause to my report to pull the Planned Start date for a task in which the name contains "XXX" and it has children tasks.

[TammyHa]

Essentially I need to pull the planned start date of the Parent task into my report. So far I have the below. I know my syntax is incorrect but I can't figure it out. Anyone have any ideas??

displayname=XXX

listdelimiter=

listmethod=nested(tasks).lists

textmode=true

type=iterate

valueexpression=IF(CONTAINS("XXX Release",{name},&&{numberOfChildren}ne,0),{plannedStartDate})

valueformat=HTML

[AdinaPi1]

Is this on a project report?

[TammyHa]

Yes - It is a project report with several collections fields on it.

[NicholeVargas]

@Tammy Hall‚

The updated text mode is below. If you have any questions, let me know!

displayname=XXX

listdelimiter=

listmethod=nested(tasks).lists

textmode=true

type=iterate

valueexpression=IF(CONTAINS("XXX Release",{name})&{numberOfChildren}!=0,{plannedStartDate})

valueformat=HTML