nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

Joining report on the Primary

SamCC

If I have 2 sheets with the same Primary column, is there a way I can use reports to create a sheet that essentially joins the 2 other sheets using that primary column, and keep that unique in the output?

Find more posts tagged with

Reports

Comments

Sheryl P

This is a big shortcoming ... and would eliminate some of the cell linking and crosssheet references I use.

Andrée Starå

Hi Sam,

Unfortunately, it's not possible at the moment, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Nicole Tellez

Yes, it's a premium add-on called Pivot. You have to purchase that feature and then you can do exactly as you are suggesting.

Andrée Starå

Thanks Nicole!

I forgot about the Premium Pivot add-on.

More info: https://help.smartsheet.com/learning-track/add-ons/pivot-app

Best,

Andrée

Sheryl P

Thank you - I missed that add-on

Samuel Mueller

Can someone explain the point of the primary column if not to match data from different sheets into one report? Am I misunderstanding something?

Sign in to join the conversation!

Quick Links

Trending discussions

Automation--Copying Rows
When using automation to copy checked rows from source sheet, no destination sheets populate for me to choose from even though I am Admin on both sheets. Has anyone experienced this? Any trouble shoots or resolutions? Thanks.
Update Request Automation Not Triggering
Hello Smartsheet Friends! I recently switched jobs and once again working at a company that uses Smartsheet (hooray!). That said my skills are a little rusty, and I'm struggling with a basic update request automation. I've added a checkbox column titled 'Product Owner Update'. The intent, is that when a user checks the…
Create a sheet to store project details and weekly updates
Hi My team have a list of projects they are working on. I want to prompt them for a weekly update that will ask them to populate these fields - RAG Status , Progress this week , Plan Next week, Risks/Decision/Issues , Details Then i can create a dashboard showing only this weeks info but i have the repository in the back…