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? 

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?