Pivot Table Source
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.
Thanks
Best Answer
-
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!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
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??
-
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!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Right there in front of me! Thank you so much @Genevieve P!!
-
No problem at all! 🙂
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Ugh. Better refill the coffee. Haha. Thank you, Genevieve.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives