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?
Can someone help me and give me an idea on how to create a cost estimate for installations, with a total for each chapter by groups, subgroups and types of work, but at the bottom of each chapter. https://us.v-cdn.net/6031209/uploads/0OSH46KSC2LH/cost-estimate.xlsx Thanks
Hi Everyone, I created some forms for our powdercoat test logs. The forms are working great for the employees to input the data. The problem I am having is with giving the supervisors and managers access to the sheet. I gave them Editor Cannot Share permissions to see and edit the sheet. But they are saying that Smartsheet…
Hello There , before smartsheet switched to the new license type, the users to whom I gave editing permissions could not share the page unless I granted them permission. In addition, users did not have the ability to create pages. This way, as the admin, I was aware of all the pages created in the company and could…
