Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Tasks in a Column within a Project Report

Avatar

Level 1

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

 

 

3 Replies

Avatar

Level 1

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.

Avatar

Level 1

Hello Racheal,

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

 

Avatar

Level 4

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

Ry_93E9BE_1-1659473026701.png

result 

Ry_93E9BE_0-1659472938628.png