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?
I have imported a fillable PDF form and have moved over all of the corresponding tabs. When I hit save to generate the form it get the following: To generate documents, please add some content to your sheet. Any ideas?
Hello, Our Task Tracker sheet is used to manage and collaborate on internal tasks. Each team member received a daily email containing all tasks assigned to them, and we all LOVE the update request feature where we use a webpage that resembles a form to review & update each request, click next, go through all tasks, and…
This is what I would like to accomplish using Smartsheets but I am struggling to find the best way to go about it. Each year we get new vegetable varieties that we need to test in various locations at different times. I would like a tool that I can follow each variety up with a grower. The following data is added:…
