Primary column not returning values in Report

Bonnie du Plessis

I am creating a report using data from 5 different sheets. All 5 sheets use the same columns, including a primary column called Project Name. The column has data in on all 5 sheets, however this data is not showing in the report.  Interestingly, when I print the report to pdf, I see the project name values. 

Andrée Starå

Hi Bonnie,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Bonnie du Plessis

Hi Andree, I'm attaching screenshotss. 

You'll see there is data in the Project Name field in the sheet.  When I pull that field into a report, nothing shows in that column.  However, when I add the report to a dashboard, the data is displayed. 

.

Andrée Starå

It looks like it's not the primary column in the second screenshot. Could that be the reason?

Hope that helps!