Pivot Table Source

Andrea Westrich · 06/15/21

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. · 06/16/21

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 · 06/15/21

You will need to be shared to the source sheet.

Andrea Westrich · 06/15/21

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

Paul Newcome · 06/15/21

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

Andrea Westrich · 06/15/21

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

Paul Newcome · 06/16/21

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. · 06/16/21

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 · 06/16/21

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

Genevieve P. · 06/16/21

No problem at all! 🙂

Paul Newcome · 06/16/21

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

Pivot Table Source

Best Answer

Answers

Categories