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?
This is a big shortcoming ... and would eliminate some of the cell linking and crosssheet references I use.
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
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.
Thanks Nicole!
I forgot about the Premium Pivot add-on.
More info: https://help.smartsheet.com/learning-track/add-ons/pivot-app
Andrée
Thank you - I missed that add-on
Can someone explain the point of the primary column if not to match data from different sheets into one report? Am I misunderstanding something?
Hi All, Need you support for the the issue. I was in the process of making an approval workflow for petty cash request, the problem was when i want to combine 2 different confirmation workflow by Requester to be appear in same column (Confirm), but mention notification like in the screenshot attached. The workflow consist…
A report is not available to be a data source for a Metric Widget. I have a report that shows the one figure I want to be displayed on a dashboard. I cannot convert the report to a sheet and cannot seem to get the report number on my report to the Metric Widget… Can this functionality be added to use a report for a data…
New to smart sheet pro and I desire to share to viewer, share tab not activated...how do I activate and share a sheet with a viewer?
