Sign in to join the conversation:
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?
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
