Expand my Community achievements bar.

Adding Team Members & Color Coding to reports

Avatar

Level 1
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
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

3 Replies

Avatar

Level 10
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=f893df... -skye

Avatar

Level 1
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

Avatar

Level 10
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