Report with multiple source sheets

Hi -

Having trouble building a report using 3 different source sheets. They don't all have the same columns, but they have the same primary column. 2 sheets are in the same workspace (let's call these Sheet A and Sheet B), 1 is in a different workspace (sheet C).

Even why i try to make a report for Sheet A and B, it is only showing information for Sheet A. I'm not the owner of these 2 sheets; however, i do own Sheet C.

Not sure what I'm doing incorrectly here ... appreciate any guidance!

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @aecross

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

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!

aecross

Hi @Andrée Starå

Not sure what kind of screen shots would be helpful to see, but here are a few. Please let me know if you need more.

Here is the sheet that i own - store name is the primary column.

The other 2 sheets are the exact same (but separate due to different regions). Store name is also the primary column here.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.