Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

@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