How can I combine two sheets into a report?

Bee-Eng Ang

I created a report and chose 2 sheets as my source. The columns from one of the sheets are not showing any value. I checked that value in "Primary" columns of both sheet are identical. May I know if I have missed anything? Thank you for your guidance!

Some notes about the screenshot of my report below.

Column "Management Flag" and "Remark" are from one sheet, and they are displaying values correctly. Whereas the last column in the below screenshot/report, "Project Objective" comes from another sheet. And the entire column is empty.

SPIPMO

Hi @Bee-Eng Ang

Please check the column properties of Project Objectives for both sheets.

Does Project Objectives is dropdown or text/number? Make sure that both column are same properties if not one will not show the value.

Hope this helps!

che

spi.pmo

Bee-Eng Ang

thanks for your prompt response che. To clarify, the column that is common between the 2 sheets is "Project Name", not "Project Objective". Do you mean for me to check that "Project Name" columns at both sheet is having the same data type?

Andrée Starå

Hi @Bee-Eng Ang

I hope you're well and safe!

Also, ensure that you're using the right type of report (row/summary)

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!