status can be replaced with plannedCompletionDate projectedCompletionDate plannedStartDate etc Here's my notes page on project columns to give you some more ideas:
Listdelimiter defaults to comma. The < br > displays a line break. & zwj ; is a zero-width joiner and doesn't add any extra characters. < div > is my new favorite as this displays on a seperate line but squashes multiples down to a single line break. (Remove spaces between < > and around the zwj) We only want to put data in for the "trues" there is no-way to a check all and then do a summary. The nested lists perform the value expression on each element of the list.
Project Team - List all project users with their role:
displayname=Project Team
listdelimiter=< div >
listmethod=nested(projectUsers).lists
textmode=true
type=iterate
valueexpression=CONCAT({user}.{name}," - ",{user}.{role}.{name})
valueformat=HTML
Milestone Name - Planned Completion Date - Condition - Task Status
displayname=Milestone Tasks
listdelimiter=
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF(ISBLANK({milestoneID}),"",CONCAT({milestone}.{name},"-",{plannedCompletionDate},"-",{progressStatus},"-"{status}," "))
valueformat=HTML
IF(CONTAINS("LT",{progressStatus}),"Late",IF(CONTAINS("ON",{progressStatus}),"On Time",IF(CONTAINS("BH",{progressStatus}),"Behind","At Risk")))
IF(CONTAINS("NEW",{status}),"New",IF(CONTAINS("INP",{status}),"In Progress",IF(CONTAINS("CPL",{status}),"Complete","")))
Specific Roles Column, replace Art Director with your role:
displayname=Art Director
listdelimiter=
listmethod=nested(projectUsers).lists
textmode=true
type=iterate
valueexpression=IF(CONTAINS("Art Director",{user}.{role}.{name}),{user}.{name})
valueformat=HTML
Specific Task Date - Report on the Date for a specific task
displayname=DTV Date
listdelimiter=
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF(CONTAINS("File to Requestor",{name}),{plannedCompletionDate})
valueformat=shortDate
Current Task - Show which task is currently being worked in the project
displayname=Current Task
listdelimiter=< div >
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({numberOfChildren}=0,IF({canStart},IF(CONTAINS("CPL",{status}),"",CONCAT({name}," "))))
valueformat=HTML
Current Task - With Planned Completion Date
valueexpression=IF({numberOfChildren}=0,IF({canStart},IF(CONTAINS("CPL",{status}),"",CONCAT({name}," - ",{plannedCompletionDate}))))
listdelimiter=< div >
listmethod=nested(tasks).lists
valueformat=HTML
displayname=Current Task
textmode=true
type=iterate
Edit Custom Forms in a pop-up window:
displayname=Click to Edit
linkedname=direct
namekey=category.name
textmode=true
tile.name=component.objectcategories
valuefield=customFormsNames
valueformat=HTML
viewalias=category.name
All Roles on a Project
displayname=Job Roles
listdelimiter=
listmethod=nested(roles).lists
textmode=true
type=iterate
valueexpression=CONCAT({name})
valueformat=HTML
This can also be put on a task level report by adding project. In front of the collection name:
displayname=Art Director
listdelimiter=
listmethod=nested(project.projectUsers).lists
textmode=true
type=iterate
valueexpression=IF(CONTAINS("Art Director",{user}.{role}.{name}),{user}.{name})
valueformat=HTML
Looks to see if role is on a project and who is filling the role, replace Copywriter with the name of the role. Blank is not on the project, Yes means it's on the project. Yes blank is unassigned, Yes name is assigned.
column.3.valueexpression=IF(CONTAINS("Airplane",{name}),"Yes ","")
column.3.type=iterate
column.3.listmethod=nested(roles).lists
column.3.sharecol=true
column.3.listdelimiter=< div >
column.3.textmode=true
column.3.valueformat=HTML
column.3.displayname=Airplane
column.4.valueformat=HTML
column.4.displayname=Spacer
column.4.textmode=true
column.4.width=1
column.4.sharecol=true
column.4.valuefield=< div >
column.5.valueformat=HTML
column.5.type=iterate
column.5.listmethod=nested(Airplane).lists
column.5.listdelimiter=< p >
column.5.textmode=true
column.5.valueexpression=IF(CONTAINS("Airplane",{role}.{name}),CONCAT({user}.{name}," ")) Melinda Layten Technical Project Manager - API and Integration Workfront -------------
