Reports not showing data from Sheet in cells.
I have two Sheets; one for a project’s status on all services, and another Sheet for all the details of the project, with “Project Name” linked in both sheets.
I go to make a report for one of the services, which pulls data from both sheets (or SHOULD at least).
In the Report Builder, I choose the two sheets in the “Where?” option, and then choose the columns I want to be displayed from the two sheets in the “What?” option and run the report builder.
Cells in some columns (from the status Sheet) display data and behave normally while other cells in other columns (from the details Sheet) are totally blank and won’t right click or respond in any way.