Task Collection Text Mode

[MoniqueEvans]

I am once again coming to all of you to help me with the text mode for my task collection. I have a Project report and can successfully pull the task collection to show the name and planned completion date but whenever I attempt to also add the parent name I get an error. The closest I came is parent ID which of course is a hot mess, but here is that code:

valueexpression=IF({numberOfChildren}=0,CONCAT({parentID},'-',{name},' - ',{plannedCompletionDate}))

[skyehansen · Accepted solution]

that's weird... API explorer implies {parent}.{name} should have worked... is this what's giving you the error?

[MoniqueEvans]

Thanks, Skye!! 100% human error, forgot the "."

That's what I get for trying to be productive on a Friday

[GrahamJarrett]

You do not have a false statement for the IF condition

Try...

valueexpression=IF({numberOfChildren}=0,CONCAT({parentID},'-',{name},' - ',{plannedCompletionDate}),"")