Pivot Table Source

Andrea Westrich

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

Genevieve P.

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"

https://community.smartsheet.com/discussion/comment/294999#Comment_294999

Let me know if you're able to find it, now!

Cheers,

Genevieve

Paul Newcome

You will need to be shared to the source sheet.

Andrea Westrich

Thanks @Paul Newcome. If I am, how do I see what sheet it is?

Paul Newcome

If you go to the main list of pivot sheets, click on the small sheet icon to the right.

Andrea Westrich

Thanks @Paul Newcome. When I go there it shows the Config name and the Pivot table name, but not the source sheet.

Paul Newcome

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??

Genevieve P.

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"

https://community.smartsheet.com/discussion/comment/294999#Comment_294999

Let me know if you're able to find it, now!

Cheers,

Genevieve

Andrea Westrich

Right there in front of me! Thank you so much @Genevieve P!!

Genevieve P.

No problem at all! 🙂

Paul Newcome

Ugh. Better refill the coffee. Haha. Thank you, Genevieve.