Report Not Showing Selected Data
I have a report that needs to pull data from two different sheets. The main items (studio, title) are the same on both sheets. One sheet has our dates of production, the other has links and metadata. I created a report that has both sheets, making sure the cell types match and can get the main page with the bulk of the data to fill in, but for some reason, I have columns showing for the dates of production, but the cells are empty. (They are not empty on the main sheet.) At one point I had it showing the DOPs, but it listed each studio/title twice to do that. This report worked fine before, we simply changed where the data was being pulled from.