Is there a report that shows related projects in same Campaign?

[Christina_Jarosz]

I'm looking for help for a filter that returns a list of projects in the same campaign as the existing project.

For instance, if Project A is part of Campaign ABC, I want a report that will return a list of projects also in Campaign ABC such as Project B and Project C, etc.

Ideally, I'll add this as a dashboard in the project itself so it can be easily viewed.

[RandyRoberts · Accepted solution]

Is there some field in your projects that shows relations to other projects? if you house related projects in a program, you can just pull info on projects in a project report by filtering the program.

[Christina_Jarosz]

There's a field that says "if this project should be part of a program, select the program here"

But how can I get ONLY that program to populate on a report without identifying the program each time?

I could say "On Project A list the program assigned (being Campaign ABC) but I'd have to specify Campaign ABC each time for a report, right?

I don't think there's a way to wildcard filter on program.