Expand my Community achievements bar.

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.

Avatar

Level 2

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

Topics

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

3 Replies

Avatar

Level 2

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

Avatar

Employee Advisor

@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