We made a custom field called "Set" for when a project has more than one deliverable.
For example: A set of 5 digital ads that all have the same copy but have five different sizes. A set of 2 flyers that again have identical copy except one is in English and one is in Spanish.
We wanted an easy way of allowing stakeholders to put in one project request but give transparency when a single project might have a variable amount of materials as that obviously impacts production time, annual metrics for appropriate staffing, etc.
I can't figure out how to incorporate the custom field to display in the annual report I'm making of all projects started in 2020 and ended in 2020. (or for any other year, individual team member, etc.)
I can make two reports where I either set the field equal to zero or greater than zero...but now I'm juggling two reports ... and I still would have to drill into the dozens and dozens of projects to see the actual number in the set.
Any suggestions on how to get a report with a column displaying the custom field value - in this case, the set number?
Would greatly appreciate any help!!