Adding Team Members & Color Coding to reports | Community
Skip to main content
March 29, 2019
Question

Adding Team Members & Color Coding to reports

  • March 29, 2019
  • 3 replies
  • 776 views
I'd love for my weekly status report to include a column with team members names. And I'd also like the report to be color coded by status, i.e. On Hold in blue, Current in pink, etc. I wasn't able to find these options when setting up the report. Can anyone suggest how to do this? Please and thanks! Cheers Stephanie Foyer PSJH
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

Level 10
March 29, 2019
hi Stephanie, your question about color coding can probably be answered by this link: "https://support.workfront.com/hc/en-us/articles/217195897-Using-Conditional-Formatting-in-Views" title="https://support.workfront.com/hc/en-us/articles/217195897-Using-Conditional-Formatting-in-Views">https://support.workfront.com/hc/en-us/articles/217195897-Using-Conditional-Formatting-in-Views your question about team members, I assume is talking about project team members? I have some coding I use for that, and you can find that searching through the archives for this post: "https://community.workfront.com/discussions/community-home/digestviewer/viewthread?MessageKey=f893dfcf-12d5-4f52-91a2-2834300b69a0&CommunityKey=ccf3381b-a473-4ef2-9f81-4dd3244cf522&tab=digestviewer#bmf893dfcf-12d5-4f52-91a2-2834300b69a0" title="https://community.workfront.com/discussions/community-home/digestviewer/viewthread?MessageKey=f893dfcf-12d5-4f52-91a2-2834300b69a0&CommunityKey=ccf3381b-a473-4ef2-9f81-4dd3244cf522&tab=digestviewer#bmf893dfcf-12d5-4f52-91a2-2834300b69a0">https://community.workfront.com/discussions/community-home/digestviewer/viewthread?MessageKey=f893dfcf-12d5-4f52-91a2-2834300b69a0&CommunityKey=ccf3381b-a473-4ef2-9f81-4dd3244cf522&tab=digestviewer#bmf893dfcf-12d5-4f52-91a2-2834300b69a0 -skye
April 2, 2019
Hi Skye - This is super helpful - thank you! I was able to color code the Status column very easily. In order to create a column that lists the Project Team Members where would I drop this code/what are the steps? displayname=Project Team listdelimiter= listmethod=nested(projectUsers).lists textmode=true type=iterate valueexpression=IF({user}.{isActive}="Yes",CONCAT({user}.{name}," | "),"") valueformat=HTML Thanks! Stephanie Foyer PSJH
Level 10
April 2, 2019
oh, sure, no problem. This link should help. "https://support.workfront.com/hc/en-us/articles/216599038-Understanding-Text-Mode" title="https://support.workfront.com/hc/en-us/articles/216599038-Understanding-Text-Mode">https://support.workfront.com/hc/en-us/articles/216599038-Understanding-Text-Mode -skye