Task Collection Text Mode

Question

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 Answer

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

GrahamJarrett · Answer

You do not have a false statement for the IF condition Try...valueexpression=IF({numberOfChildren}=0,CONCAT({parentID},'-',{name},' - ',{plannedCompletionDate}),"")

Sign up

Login with SSO

Login to the community

Login with SSO