Copy Pivot Table

Chrissy

Please vote this up! FEATURE REQUEST ALERT!

2 things:

1. I would like the ability in the Pivot App, to "COPY" a pivot table so that it doesn't have to be recreated from scratch every time. It's a waste of time and has too much room for human error, especially when trying to organize and create data for hundreds of metrics. It is clunky and this would really serve as a time saver.
2. I would like the ability to assign permissions to a pivot table. Right now, ONLY the owner of that pivot table can make adjustments to it or even see it, for that matter. What happens when someone is on PTO or leaves the company? It's a single point of failure and one that shouldn't be too difficult to mitigate, by just adding the permissions to the pivot table itself. Then it would be up to the administrator to ensure the person being shared TO, has the pivot table on their profile. If they do not, then maybe the owner of the pivot table gets a notification that the newly requested user of the table needs to see their system admin for rights to Pivot App.

katemalone

An incredible and useful idea!

Barb Bray

Would love to be able to copy pivot tables. Also to be able to store them to specific folders would be very useful. Permissions (specific to a pivot table AND/OR to all pivots) would be good, but would like the option to pick which way. I have over 100 pivots, so would like to be specific as to who can edit.

Genevieve P.

Hi all,
I've kept this Idea post here in regards to copying a Pivot Table, but wanted to provide you with an update on sharing Pivots!

All Admins on the underlying Pivot sheet now automatically become Admins on the Pivot! Here's more information: https://help.smartsheet.com/articles/2483301-preview-build-edit-pivot#toc-ownership-of-a-pivot-sheet

Cheers,
Genevieve