Tasks in a Column within a Project Report

[thisisxeney]

Hello,

I am struggling to get this to work:

displayname=Test
listdelimiter=<div>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF(ISBLANK({actualCompletionDate}),IF({numberOfChildren}=0,IF(CONTAINS(" Test1 ",{name}),CONCAT({plannedCompletionDate}," - ",{name}),IF(CONTAINS(" Test1 ",{name}),CONCAT({plannedCompletionDate}," - ",{name})))))
valueformat=HTML

I am trying to pull a Task within a project that is named Test1 to a column in a project level report and see it's status, but when I do this the field is blank.

Thank you,

David

[RachealRice]

Hi David,

I'm new to using TextMode, but it looks like you might have extra spaces inside your quotation marks around "Test1" so it might not be finding the name of your project to return results. I'd start there at least and see if that resolves it.

[thisisxeney]

Hello Racheal,

I also tried removing the spaces before that and still did not pull my tasks either.

[RyanKirk]

Hi David,

I cut down on the IF statements (I'm not that great with them yet). This might work for you

displayname=Current Task(s)
listdelimiter=<br>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({name}="Test 1",CONCAT(" * ",{name}," - " ,{plannedCompletionDate}),"")
valueformat=HTML

Project data

result 

[ryanbrogz1]

I'm not sure if this will get you all the way there, but this can maybe get you started.  I struggle with this text mode stuff all the time.  This snippet should show the status of a particular task name on a project level report.  This will end up showing the task status key, there's a separate conversion to get from INP to display as In Progress, CPL to show as Complete, and so on.

displayname=ZZZTask Status
listdelimiter=&zwj;
listmethod=nested(tasks).lists
querysort=status
textmode=true
type=iterate
valueexpression=IF(CONTAINS("ZZZ TASK NAME",{name}),{status})
valueformat=HTML

At worst, feel free to store this for any future reference, always good to save any snippets that work as you figure them out.