How can I see the source of a Pivot Table? When I try to edit to determine the source, the Select Sheet is unavailable. I need to verify the source to determine the accuracy of the data, but I did not create it.
Hi @Andrea Westrich & @Paul Newcome
The Source Sheet will be listed under the "Source" heading in the Pivot App:
So for Paul's example, it looks like his source sheet is called "Sales Outreach Messaging / Call Scripts"
Let me know if you're able to find it, now!
You will need to be shared to the source sheet.
Thanks @Paul Newcome. If I am, how do I see what sheet it is?
If you go to the main list of pivot sheets, click on the small sheet icon to the right.
Thanks @Paul Newcome. When I go there it shows the Config name and the Pivot table name, but not the source sheet.
My apologies. I misread your question. I can't seem to find where the source sheet is listed either. Hmm...
@Andrée Starå @Genevieve P @Mike Wilday Does anyone know where to locate the SOURCE SHEET for the data coming into a pivot table??
Right there in front of me! Thank you so much @Genevieve P!!
No problem at all! 🙂
Ugh. Better refill the coffee. Haha. Thank you, Genevieve.
With in Dynamic View's details panel is there a way you can start to type some of the drop down information to pull up that option instead of scrolling for the right one? See below 'Market' can't type. Am I doing something wrong or is this by design? If by design I vote for an update.
Hello, I am looking to leverage the Conditional Junction: Junction Match module to set a variable to ultimately decide which path to take. Taking a step back, I have 4 of the same 'When Column is Changed' triggers, which are attached to different smartsheets. Based on which smartsheet the trigger is associated with, I am…
Hello. I am a newer user of Smartsheet and am trying to identify an easy way for multiple contributors around our org to update data in a source sheet. Here is an outline of our scenario: We collect high level data of projects from around the Org in a "Combined Project List" sheet We would like to minimize access to this…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.