Joining 2 sheets into a report is not pulling data from second sheet

Peggy

Hi,

I have 2 sheets, they are both in the same workspace

Each sheet has a different primary column. Can this be the reason why the new report to pull from the two sheets, is not pulling the data?

Thanks,

Peggy

Andrée Starå

Hi @Peggy

I hope you're well and safe!

Strange!

Can you share a screenshot of the Report and the Filters?

I hope that helps!

Be safe and have a fantastic weekend!

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Gia Thinh

Hi @Peggy,

The primary column in the two sheets will always be used and shown in the report as long as the filter of your report is met by them (despite of their different column names).

You should check your filter.

Peggy

Hi Gia,

The primary column are both account name, on the two sheets.

One sheet pulls the data but the second sheet does not, and the columns are blank.

Do you know why?

Thank you,

Peggy

Andrée Starå

Hi @Peggy

I hope you're well and safe!

Strange!

Can you share a screenshot of the Report and the Filters?

I hope that helps!

Be safe and have a fantastic weekend!

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Peggy

Hi Andree - thank you for reaching out.

I ended up doing a workaround by just creating more columns in the one sheet and performing vlookups.

thanks!

Peggy

Andrée Starå

@Peggy

Excellent!

Glad you got it working!