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. | Community
Skip to main content
T
TammyHa
Level 2
August 25, 2020
Question

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.

  • August 25, 2020
  • 2 replies
  • 685 views

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    2 replies

    A
    AdinaPi1
    Level 9
    August 25, 2020

    Is this on a project report?

    T
    TammyHaAuthor
    Level 2
    August 26, 2020

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

    NicholeVargas
    Adobe Employee
    NicholeVargasAdobe Employee
    Adobe Employee
    August 26, 2020

    @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

    Terms & ConditionsAccessibility statement

    Loading footer...