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
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.
Views
Replies
Total Likes
Hello Racheal,
I also tried removing the spaces before that and still did not pull my tasks either.
Views
Replies
Total Likes
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