I have a program level custom field that I would like to highlight red on a project report IF the status of the project is Current. Any way to do this? I'd like to do it in the report rather than create a custom field. I'm also thinking this may not be possible to do because the field is at the program level not the project level. Feedback appreciated. Thanks!
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Hi - you can reference program level data in a project report easily and conditional formatting is easy too (as long as you only have one condition you are looking at.
Step 1: the field
Step 2: conditional formatting
Step 3: If program's custom form didn't show up in field library
Let me know if that helps :)
Hi, Thanks for the response. I had gotten that far though :-) I want to make the formatting conditional on the status of the project. If project status is Current AND the program level custom field is blank, then highlight the cell red. Right now my condition is If blank highlight red.
Views
Replies
Total Likes