Expand my Community achievements bar.

SOLVED

Text mode Help for "Current Task" view column

Avatar

Level 1

I'm trying to have a column at my Program level and Project level to show me what task we are on, who it's assigned to and the due date. I started with the text mode below but it's not working for me. Anyone ideas what I have wrong here? 

 

 

displayname=Current Task

listdelimiter=<div> listmethod=nested(tasks).lists textmode=true type=iterate usewidths=true

valueexpression=IF({numberOfChildren}=0,IF({canStart},IF(CONTAINS("CPL",{status}),"",CONCAT({name}," - ",{assignedTo}.{name}," - ",{plannedCompletionDate}))))

valueformat=HTML width=400

1 Accepted Solution

Avatar

Correct answer by
Level 1

That's it - Thank you!!!

View solution in original post

3 Replies

Avatar

Level 4

Hi @Kim_Hodnett,

 

I have refactored this a bit, added new lines, removed some extra spaces and it works normally/as intended I would say. Could you please try this

 

displayname=Current Task
listdelimiter=<div>
listmethod=nested(tasks).lists
type=iterate
usewidths=true
valueexpression=IF({numberOfChildren}=0,IF({canStart},IF(CONTAINS("CPL",{status}),"",CONCAT({name}," - ",{assignedTo}.{name}," - ",{plannedCompletionDate}))))
valueformat=HTML
width=400

 

Please let me know if it works now. 

 

Best regards,
Ivan

Avatar

Correct answer by
Level 1

That's it - Thank you!!!

Avatar

Level 4

Hi @Kim_Hodnett ,

 

Could you also mark this as correct, so its helps community with finding the solution in the future. Thank you in advance, appreciate it.

 

Best regards,
Ivan